IBM Support

IC79769: DB2 SERVER MAY HANG AFTER A TRAPPED THREAD IS SUSTAINED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 server may hang after DB2 sustains a trapped thread. The
    db2diag.log may contain entries like the following:
    
    2011-10-30-16.57.58.035757-240 I14561153A541      LEVEL: Severe
    PID     : 840548               TID  : 14737       PROC : db2sysc
    2
    ...
    FUNCTION: DB2 UDB, RAS/PD component,
    pdResilienceIsSafeToSustain, probe:800
    DATA #1 : String, 37 bytes
    Trap Sustainability Criteria Checking
    DATA #2 : Hex integer, 8 bytes
    0x0000000400003001
    DATA #3 : Boolean, 1 bytes
    true
    ...
    2011-10-30-16.57.58.058740-240 E14583194A946      LEVEL: Severe
    PID     : 840548               TID  : 14737       PROC : db2sysc
    2
    ...
    (suspended)
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsTrapResilience,
    probe:800
    MESSAGE : ADM14013C  The following type of critical error
    occurred: "Trap".
              This error occurred because one or more threads that
    are associated
              with the current DB2 instance have been suspended, but
    the instance
              process is still running. First Occurrence Data
    capture (FODC) was
              invoked in the following mode: "Automatic". FODC
    diagnostic
              information is located in the following directory:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Without this APAR, customer is exposed to the issue as       *
    * described in the "ERROR DESCRIPTION" section.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7, Fixpack 6.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7, Fixpack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79769

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

  • Closed date

    2012-07-18

  • Last modified date

    2012-07-18

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

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

    IC84274

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 #: IC79769

Modified date: 18 July 2012