IBM Support

IC82403: CRASH RECOVERY OR ROLL FORWARD OPERATION MIGHT FAIL WHEN CERTAIN LOG RECORDS ARE REPLAYED ON A TABLE WITH COMPRESSION ENABLED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During a crash recovery or roll forward operation, a table with
    compression enabled for both relational and XML data might
    become corrupted when a log record is replayed against that
    table as the result of a TRUNCATE TABLE or LOAD REPLACE command.
    The compression dictionary might be damaged and as a result, the
    table data might become inaccessible. If this happens, during
    the crash recovery operation you might see the connection to the
    server failing with SQL1042C error message.
    
    "db2 => CONNECT TO XMLDB
    SQL1042C  An unexpected system error occurred.  SQLSTATE=58004"
    
    and You might also see a message similar to the following one in
    the db2diag log file:
    
    2011-03-23-08.46.38.358819-240 E13646500A485      LEVEL: Error
    PID     : 17703                TID  : 8           PROC : db2sysc
    INSTANCE: sample          NODE : 000         DB   : XMLDB
    APPHDL  : 0-7                  APPID:
    *LOCAL.regress3.110323124629
    AUTHID  : DBUSER
    EDUID   : 8                    EDUNAME: db2agent (XMLDB)
    FUNCTION: DB2 UDB, base sys utilities,
    sqeLocalDatabase::RecoverDatabase, probe:60
    MESSAGE : ADM1532E  Crash recovery has failed with SQLCODE
    "-1042".
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of table compression                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the most recent fix pack.                         *
    ****************************************************************
    

Problem conclusion

  • Problem is first fixed in DB2 UDB version 9.7 fix pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82403

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-01

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC82403

Modified date: 06 June 2012