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

db2pd -stack all or db2pd -dump all may crash the instance with signal 11.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
db2pd -stack all or db2pd -dump allmay crash the instance in 
pthread_kill() where pthread_kill() got 0 as tid parameter. 
 
Here is sample of stack trace. 
 
<POFDisassembly> 
 
 pthread_kill + 0x0000  (/lib64/libpthread.so.0) 
 
        0x00000035CB60B980 : 8B8F90000000BF03 
</POFDisassembly> 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002B1059B44E9F ossDumpStackTraceEx + 0x01ef 
                (/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002B1059B3FC5E _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
                (/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002B1056C172B6 sqlo_trce + 0x040a 
                (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002B1056C5C9D8 sqloEDUCodeTrapHandler + 0x025a 
                (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00000035CB60E7C0 address: 0x00000035CB60E7C0 ; dladdress: 
0x00000035CB600000 ; offset in lib: 0x000000000000E7C0 ; 
                (/lib64/libpthread.so.0) 
0x00000035CB60B980 pthread_kill + 0x0000 
                (/lib64/libpthread.so.0) 
0x00002B1056C5BEA6 sqloUNIXSignalEDU + 0x0144 
                (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x000000000040B04D _Z14sqleRunSysCtlrv + 0x01ed 
                (db2sysc)
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 10.1 fixpack 4.                   * 
****************************************************************
Local Fix:
Increase NUM_POOL_AGENT, NUM_INIT_AGENT.
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 10.1 FixPack 4.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.09.2013
09.06.2014
09.06.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList