home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC80426 Status: Closed

SEVERE SQLOMEMDETACHFROMSEGMENTS MESSAGE LOGGED BY DB2ROCM PROCESS USING
PURESCALE FEATURE

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
A severe diagnostic message with the function 
"sqloMemDetachFromSegments" may be logged to the db2diag.log 
unnecessarily by the db2rocm process when using the DB2 
pureScale feature.  The error is related to a harmless expected 
condition and will be removed. 
 
db2diag.log example: 
 
2011-11-29-19.43.55.384847+540 I2751121A1425        LEVEL: 
Severe (OS) 
PID     : 21758068             TID  : 1             PROC : 
db2rocm 2 [db2inst] 
INSTANCE: db2inst              NODE : 002 
HOSTNAME: host1 
EDUID   : 1                    EDUNAME: db2rocm 2 [db2inst1] 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloMemDetachFromSegments, probe:100 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
CALLED  : OS, -, shmdt 
OSERR   : EINVAL (22) "Invalid argument" 
DATA #1 : unsigned integer, 8 bytes 
0 
DATA #2 : unsigned integer, 8 bytes 
1 
DATA #3 : Pointer, 8 bytes 
0x0a00040000000000 
CALLSTCK: 
  [0] 0x090000000566BF20 pdLogSysRC@glue45B + 0x11C 
  [1] 0x0900000005431320 
@84@sqloMemDetachFromSegments__FPCvCUlCb + 0xA0 
  [2] 0x090000000566DA98 
sqloMemDetachFromSegments__FPCvCUlCb@glue52A + 0x78 
  [3] 0x09000000054328AC 
@84@sqloMemDetachFromSharedMemory__FCP12SQLO_MEM_SETCbT2 + 0xA4 
  [4] 0x090000000B3C3348 sqlodshr + 0x148 
  [5] 0x00000001000093E4 
sqlhaDbmsDetach__FPA85_lP18SQLHA_SHMEM_HANDLE + 0x1E4 
  [6] 0x000000010000DFC0 
sqlhaMonitorPartition__FsUlP23SQLO_PGRP_FILE_CONTENTS + 0x1C0 
  [7] 0x000000010000FA44 
sqlhaMonitorPartitionAndLog__FsUlP23SQLO_PGRP_FILE_CONTENTS26_sq 
lhaExpectedMonitorState + 0x284 
  [8] 0x0000000100007828 rocmDB2Monitor + 0x48 
  [9] 0x0000000100002C64 main + 0x1284 
  [10] 0x0000000100000320 __start + 0x98 
 
2011-11-29-19.43.55.819036+540 I2752547A1763        LEVEL: Error 
PID     : 21758068             TID  : 1             PROC : 
db2rocm 2 [db2inst1] 
INSTANCE: db2inst1              NODE : 002 
HOSTNAME: host1 
EDUID   : 1                    EDUNAME: db2rocm 2 [db2inst1] 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloMemDetachFromSharedMemory, probe:220 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
DATA #1 : Memory set handle, PD_TYPE_OSS_MEM_SET_HDL, 48 bytes 
0x0FFFFFFFFFFFD798 : 0780 0000 0000 0000 0780 0000 0000 0000 
................ 
0x0FFFFFFFFFFFD7A8 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFFD7B8 : 0000 0000 0A2E 0000 0180 001A 0000 0002 
................ 
DATA #2 : Chunk group, PD_TYPE_CHUNK_GROUP, 64 bytes 
0x0780000000001E48 : 0000 0000 0000 0000 0780 0000 0000 1E08 
................ 
0x0780000000001E58 : 0A00 0400 0000 0000 07F0 001E 0000 0000 
................ 
0x0780000000001E68 : 0080 2044 0000 0007 0000 0007 0000 0001 
.. D............ 
0x0780000000001E78 : 0780 0000 0000 0000 0780 0000 0000 02C0 
................ 
CALLSTCK: 
  [0] 0x090000000B063170 pdLog@glue663 + 0xD4 
  [1] 0x09000000054328E0 
@84@sqloMemDetachFromSharedMemory__FCP12SQLO_MEM_SETCbT2 + 0xD8 
  [2] 0x090000000B3C3348 sqlodshr + 0x148 
  [3] 0x00000001000093E4 
sqlhaDbmsDetach__FPA85_lP18SQLHA_SHMEM_HANDLE + 0x1E4 
  [4] 0x000000010000DFC0 
sqlhaMonitorPartition__FsUlP23SQLO_PGRP_FILE_CONTENTS + 0x1C0 
  [5] 0x000000010000FA44 
sqlhaMonitorPartitionAndLog__FsUlP23SQLO_PGRP_FILE_CONTENTS26_sq 
lhaExpectedMonitorState + 0x284 
  [6] 0x0000000100007828 rocmDB2Monitor + 0x48 
  [7] 0x0000000100002C64 main + 0x1284 
  [8] 0x0000000100000320 __start + 0x98
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Diagnostic message can be ignored                            * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 Version 9.8 Fix Pack 5
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84508 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.12.2011
18.07.2012
18.07.2012
Problem solved at the following versions (IBM BugInfos)
9.8.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.5 FixList