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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

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

Local fix

  • Increase NUM_POOL_AGENT, NUM_INIT_AGENT.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.7 fixpack 9.                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC94312

  • 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

    2013-07-23

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC94312

Modified date:

2013-12-23

Translate my page

Machine Translation

Content navigation