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 | |
| 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 |
|