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 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
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList