IBM Support

IC79723: DB2FMP PROCESS WOULD BE TERMINATED BY "DB2PD -STACK ALL" ON LINUX PLATFORM

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

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

Local fix

  • Stop running command "db2pd -stack all", reset the connection;
    Or
    If you are running on SLES10 SP2 or lower, upgrade to SP3.
    

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

Problem conclusion

  • Firstly fixed in Federation Server V9.7 FP6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79723

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-09

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79723

Modified date: 06 June 2012