DB2 - Problem description
Problem IC79723 | Status: Closed |
DB2FMP PROCESS WOULD BE TERMINATED BY "DB2PD -STACK ALL" ON LINUX PLATFORM | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Command "db2pd -stack all" would kill db2fmp process by mistake on a linux platform. You can see stacktrace as below from the db2fmp trap file: <Registers> rax 0x000000000000002c rbx 0x00002aaaac6ca900 rcx 0x00007fffffffd850 rdx 0x0000000000000017 rbp 0x00007fffffffde00 rsp 0x00007fffffffd848 rsi 0x0000000000000017 rdi 0x0000000000000001 rflags 0x0000000000010206 rip 0x00002aaaacd8fe72 r8 0x0000000000000008 r9 0x00002aaaad4008c0 r10 0x0000000000000000 r11 0x00002aaaacd8fe70 r12 0x00007fffffffdc88 r13 0x00002aaaaf04dcb0 r14 0x0000000000000001 r15 0x0000000000000000 </Registers> <POFDisassembly> pthread_kill + 0x0002 (/lib64/libpthread.so.0) 0x00002AAAACD8FE72 : 8BB790000000B903 </POFDisassembly> <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAAC8E9F2D ossDumpStackTraceEx + 0x01e5 (/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAAC8E4CB2 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc (/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAAB8620D3 sqlo_trce + 0x0365 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAAB863594 sqlo_db2fmp_trca_nokill + 0x0092 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAACD92C00 address: 0x00002AAAACD92C00 ; dladdress: 0x00002AAAACD85000 ; offset in lib: 0x000000000000DC00 ; (/lib64/libpthread.so.0) 0x00002AAAACD8FE72 pthread_kill + 0x0002 (/lib64/libpthread.so.0) 0x00002AAAAB6A9B71 sqlerDumpFmpThreadInfo + 0x00a7 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAAB863336 sqlo_db2fmp_sigpre + 0x0088 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAACD92C00 address: 0x00002AAAACD92C00 ; dladdress: 0x00002AAAACD85000 ; offset in lib: 0x000000000000DC00 ; (/lib64/libpthread.so.0) 0x00002AAAAD3C0C97 semop + 0x0007 (/lib64/libc.so.6) 0x00002AAAAB11C5B9 sqloSSemP + 0x00e5 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAAB646A0E _Z21sqlccipcdarihandshakeP18SQLCC_INITSTRUCT_TP17SQLCC_COMHANDLE _T + 0x00ca (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x00002AAAAB6AB635 sqlerMasterThreadListener + 0x07c5 (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 0x0000000000403E98 main + 0x1000 (db2fmp () 0x00002AAAAD31C184 __libc_start_main + 0x00f4 (/lib64/libc.so.6) 0x0000000000402E09 __gxx_personality_v0 + 0x00b9 (db2fmp () </StackTrace> <ProcessObjects> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * The user is running fenced mode wrapper and submitting * * command "db2pd -stack all" on a linux box. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Federation Server V97FP6 or later. * **************************************************************** | |
Local Fix: | |
Stop running command "db2pd -stack all", reset the connection; Or If you are running on SLES10 SP2 or lower, upgrade to SP3. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Solution | |
Firstly fixed in Federation Server V9.7 FP6. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.11.2011 06.06.2012 06.06.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP6 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.6 |