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 IC62523 Status: Closed

DB2WDOG PROCESS TRAP IN SQLECREATEFMP AND BRING DOWN THE INSTANCE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Users effected:  DB2 UDB v9.5 and v9.7 users 
Problem description: 
 
Instance trap due to db2wdog process receives signal #11 
 
sample db2diag.log entry: 
 
2009-06-06-13.27.15.061362-240 E66710914A2199     LEVEL: 
Critical 
PID     : 8573                 TID  : 2           PROC : db2wdog 
INSTANCE: db2inst1             NODE : 000 
EDUID   : 2                    EDUNAME: db2wdog 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:10 
MESSAGE : ADM14001C  An unexpected and critical error has 
occurred: 
"Trap". The 
         instance may have been shutdown as a result. 
"Automatic" FODC 
(First 
         Occurrence Data Capture) has been invoked and 
diagnostic 
information 
         has been recorded in directory 
 
"/db2home/db2inst1/sqllib/db2dump/FODC_Trap_2009-06-06-13.27.05. 
64599 
         2/". Please look in this directory for detailed 
evidence about 
what 
         happened and contact IBM support if necessary to 
diagnose the 
         problem. 
DATA #1 : Signal Number Recieved, 4 bytes 
11 
DATA #2 : Siginfo, 256 bytes 
 
Trap file shows: 
 
EDU name     : db2wdog 
EDU ID       : 2 
Signal #11 
uname: S:SunOS R:5.10 V:Generic_120011-14 M:sun4u 
N:db2sunprod01.rack.peerplace.com 
process id: 8573 
thread id : 2 (0x2) 
</Header> 
 
<StackTrace> 
##### Object: /db2home/db2inst1/sqllib/adm/db2syscr 
__1cNsqleCreateFmp6FpcpnQSQdDLO_EDUWAITPOST_pi_i_(0xffffffff607f 
d240,0x2 
02593918,0x1000009fde0,0x10238c,0x0,0x1c00) + 0x1c 
__1cMsqleWatchDog6FL_i_(0x0,0x1,0xffffffff7e983c70,0x2,0x1001117 
90,0xfff 
fffff607fd1e8) + 0x938 
DB2main(0x0,0x100111120,0x49,0x18280000,0x1,0x10010e2c8) + 0xabc 
##### Object: /opt/IBM/db2/V9.5/lib64/libdb2e.so.1 
sqloEDUEntry(0xffffffff7ffffa20,0x2,0xa10210,0xffffffff7f09e928, 
0x187800 
00,0xffffffff7e615ce0) + 0x130 
##### Object: /lib/sparcv9/libc.so.1 
_thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x484 
</StackTrace> 
 
Root cause is due to db2wdog process failed to attach to the 
newly created DBMS shared memory set.  So when fmp tries to 
allocate a memory block, wrong memory address is being accessed.
Problem Summary:
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Workaround
not known / see Local fix
Comment
This APAR is a duplicate of IC63524
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.08.2009
17.12.2009
17.02.2010
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList