IBM Support

IC85562: IN RARE CASE, A ROLLBACK TRANSACTION HITS MAX_LOG IN DB2 LUW DPF ENVIRONMENT CAUSING HANG OR MARK DATABASE BAD.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In DB2 LUW DPF environment, if a transaction hits MAX_LOG on
    some partitions, DB2 forces it off and rolls back the
    transaction. In rare case, this rollback may hang or mark
    database bad.
    
    If it hangs, you will notice the transaction is not rolled back
    on some partitions and still consumes log space, and
    associated application handle is in UOW-Waiting status.
    
    If it marks database bad, DB2 may report bad table handle in
    db2diag.log similar to the following messages:
    
    2012-03-25-03.50.51.931961-300 I667503363E528      LEVEL: Severe
    PID     : 25925                TID  : 46912724003136PROC :
    db2sysc 28
    INSTANCE: db2instance             NODE : 028          DB   :
    SAMPLE
    APPHDL  : 0-34113              APPID:
    *N0.db2instance.120325053102
    AUTHID  : SAMUSER
    EDUID   : 312                  EDUNAME: db2agntp (SAMPLE) 28
    FUNCTION: DB2 UDB, data management, sqldmclo, probe:948
    RETCODE : ZRC=0x87040018=-2029780968=SQLD_BADH "BAD TABLE
    HANDLE"
              DIA8521C An incorrect table handle was encountered.
    

Local fix

  • Avoid hitting MAX_LOG, use NOT LOGGED INITIALLY feature if
    possible.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 7                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85562

  • 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

    2012-07-26

  • Closed date

    2012-12-10

  • Last modified date

    2012-12-10

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

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

    IC88646

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

Modified date: 10 December 2012