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