IBM Support

IC77149: After TAKEOVER, db2diag.log is filled with warning messages from functon hdrCheckDb.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When primary is switched to standby, all inflight transactions
    including 'e' state (ended transactions) are rollbacked. But
    ended expired transaction were not unregistered with the resync
    process.
    If application/TM sets transaction time out using
    setTransactionTimeout jdbc
    function or XATimeout (XT) variable in xaopen string (or CLI
    keyword), the following messages can be
    logged in db2diag.log in HADR system after TAKEOVER. These
    messages are logged by db2sysc (resync process), which
    tries to access the database (Now in standby mode) to rollback
    expired ended ('e' state) transactions.
    
    2011-06-01-17.00.06.422199+540 I9462838A507       LEVEL: Warning
    PID     : xxxx             TID  : xxxx       PROC : db2sysc 0
    INSTANCE: DB2             NODE : 000         DB   : SAMPLE
    
    APPHDL  : x-xxxxx
    
    EDUID   : xxxxx                EDUNAME: db2agent (xxx) 0
    
    FUNCTION: DB2 UDB, High Availability Disaster Recovery,
    hdrCheckDb,
    probe:18200
    MESSAGE : Connections are not allowed on a standby database.
    
    DATA #1 : Hexdump, 4 bytes
    
    0x078000000158B8CC : FFFF F910
    
    2011-06-01-17.00.06.423243+540 I9464649A471       LEVEL: Error
    PID     : xxxx             TID  : xxxx       PROC : db2sysc 0
    INSTANCE: db2            NODE : 000         DB   : xxxxx
    APPHDL  : x-xxxx
    EDUID   : xxxx                EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, DRDA Application Server, sqljs_ddm_syncrsy,
    probe:50
    MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
             "SQLCA has been built and saved in component specific
    control
    block."
    
    The defect fix is to unregister ended expired transaction during
    TAKEOVER process. The defect has no effect on the outcome of the
    transaction.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 v9.7 FP 3a                                               *
    * AIX                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When primary is switched to standby, all inflight            *
    * transactions including 'e' state (ended transactions) are    *
    * rollbacked. But ended expired transaction were not           *
    * unregistered with the resync process.  The message in        *
    * db2diag.log is logged when db2resync process tried to        *
    * rollback timedout or expired transactions. The defect fix is *
    * to unregister ended expired transaction during TAKEOVER      *
    * process.                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The defect fix is to unregister ended expired transaction    *
    * during TAKEOVER process.                                     *
    ****************************************************************
    

Problem conclusion

  • Problem First Fixed in DB2 Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77149

  • 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-06-24

  • Closed date

    2012-02-12

  • Last modified date

    2012-02-12

  • 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 #: IC77149

Modified date: 12 February 2012