IBM Support

IC70578: DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED SEGV CONDITIONS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 CLP(db2bp) process can trap with SEGV or consume CPU with
    nested SEGV conditions.
    
    Ensure DFT_MON_STMT = ON.
    
    1) db2pd -db <db> -appl to get the CoorPid.
    2) db2trc on -p <CoorPid-from-#1> -debug
    DB2.SQLR.sqlrr_stmt_exe_start.exit -suspend
    
    Session 1:
    3) db2 -f <the big SQL>
    
    Session 2:
    4) db2 get snapshot for applications on <db>
    [...]
    Dynamic SQL statement text:
    DB21017E  The Command Line Processor encountered a system error
    with the
    front-end process output queue. Reason code = -2029060033.
    
    
    Possible Stack:
    
    2878:    /db2/db2iwp/sqllib/bin/db2bp
    
    --------------------------------  lwpid : 1701541
    -------------------------------
    
     0: c00000001827c0f0 :
    _Z13pdLogInternalmjmjmmmmPvmP11__va_list__() + 0x44e0
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     1: c0000000184de6f0 : pdLogSysRC() + 0xd0
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     2: c000000018f1df50 : _Z21sqloLogAndMapQueErrorjjim() + 0x70
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     3: c0000000183aac30 : sqlocque() + 0x250
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     4: 400000000011f350 : _Z15clp_bp_exitlistj() + 0xf0
    (/db2/db2iwp/sqllib/bin/db2bp)
     5: 400000000011f870 : clp_bp_sigterm() + 0x170
    (/db2/db2iwp/sqllib/bin/db2bp)
     5: e0000001208828e0 : [ sendsig : signal 11 : SIGSEGV ]
     7: c000000018282b40 : sqlogmblkEx() + 0x15b0
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     8: c00000001829b170 :
    _Z15sqlowqueWrapperP13SQLO_QUE_DESCP12SQLO_MSG_HDRib() + 0xe0
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
     9: c000000018266bf0 : sqlowque() + 0x30
    (/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
    10: 40000000000513a0 : _Z8clp_wqueP12SQLO_MSG_HDR() + 0xc0
    (/db2/db2iwp/sqllib/bin/db2bp)
    11: 40000000001201f0 : _Z16clp_send_msglinei() + 0x190
    (/db2/db2iwp/sqllib/bin/db2bp)
    12: 40000000000f8e90 :
    _Z17clp_stmt_snapshotP14sqlm_collectedP20sqlm_recording_groupPcj
    ()
    + 0x1bf0 (/db2/db2iwp/sqllib/bin/db2bp)
    13: 40000000000d87e0 : _Z18clpbp_exe_sqlmonssv() + 0x22c0
    (/db2/db2iwp/sqllib/bin/db2bp)
    14: 400000000004eb40 : _Z10clp_bp_conv() + 0x6a0
    (/db2/db2iwp/sqllib/bin/db2bp)
    15: 4000000000056d60 :
    _ZN6DasAPI13setOutputArgsER13DasOutputArgs() + 0x2a0
    (/db2/db2iwp/sqllib/bin/db2bp)
    16: c00000000002be30 : main_opd_entry() + 0x50
    (/usr/lib/hpux64/dld.so)
    
    WORKAROUND:
    None
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED *
    * SEGV CONDITIONS                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 Fixpack 4 or higher.                         *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v9.7 Fixpack 4 or higher.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70578

  • 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

    2010-08-16

  • Closed date

    2011-05-09

  • Last modified date

    2011-05-09

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

    IC70576

  • 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 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70578

Modified date: 09 May 2011