IBM Support

IC99336: RESTART DATABASE FAILS WITH ERROR SQL1042C

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Restart and crash recovery of a DB2 database might fail with
    SQL1042C.
    
    Following entry will be written to the db2diag.log at the
    beginning of the crash recovery operation:
    
    2014-02-04-10.38.44.516160+060 I8094835A533       LEVEL: Severe
    PID     : 7405980              TID  : 5912        PROC : db2sysc
    0
    INSTANCE: db2v97               NODE : 000         DB   : SAMPLE
    APPHDL  : 0-53                 APPID: *N0.db2tbp.140204093845
    AUTHID  : DB2V97
    EDUID   : 5912                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:450
    RETCODE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    
    
    To hit this issue following conditions must be true:
    
    1. database configured for infinite logging (LOGSECOND -1)
    
    2. slow or not working log file archiving
    
    3. force down the database / instance
    
    4. attempt database restart while log archiving is still not
    working correctly
    
    
    Due to the second condition no log file re-name and re-use will
    take place. Log files will stay in the active log directory and
    DB2 will start to allocate new log files up to the allowed
    maximum of 256 (+ 2) since last successfully archived log file.
    This is tracked in the log file array and log file count in the
    database log control files (SQLOGCTL.LFH.1/SQLOGCTL.LFH.2).
    As soon as DB2 reached the maximum of 256 (+2) log files the
    database database will appear to hang.
    
    A forced shutdown of the database / instance to release the hang
    situation will leave the database in the need for crash recovery
    at the next activation.
    
    If the database is restarted while log archiving is still not
    working DB2 will fail to create new log files during crash
    recovery and fail with the crash recovery operation.
    In addition the log file count is further increased by 1 to 259.
    
    This is not expected and will cause any subsequent attempt to
    bring up the database to fail with SQL1042C.
    

Local fix

  • Fix the log archiving issue instead of forcing down the
    database. With log files being archived successfully again the
    database will continue to work.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 FixPack 10.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 version 9.7 FixPack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99336

  • 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

    2014-02-13

  • Closed date

    2014-11-18

  • Last modified date

    2014-11-18

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

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

    IT00476 IT00477 IT00478 IT00504 IT00511 IT00537 IT00608 IT00609

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

Modified date: 18 November 2014