IBM Support

IT30257: ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • This is a problem when log files are manually copied from
    archive to active or overflow log path for ROLLFORWARD
    and these log files were compressed during archiving (that
    is, the LOGARCHCOMPR1 /LOGARCHCOMPR2 database
    configuration parameter is set to YES). In addition, these
    log files were archived to different log chain subdirectories.
    
    The following is an example of the corresponding command:
    db2 "rollforward db JKL to end of logs overflow log path (
    /overflow/log/path ) NORETRIEVE".  The ROLLFORWARD
    command fails with SQL1042C error.
    
    The following is sample db2diag.log message associated
    with this error.
    
    2019-05-14-03.00.00.225357+120 I2042287E2555         LEVEL:
    Error
    PID     : 303                  TID : 139937382917888 PROC :
    db2sysc 0
    INSTANCE: db2jkl               NODE : 000            DB   : JKL
    HOSTNAME: hal9001
    EDUID   : 406                  EDUNAME: db2logmgr (JKL) 0
    FUNCTION: DB2 UDB, data protection services,
    sqpLogMgrEdu::sqlpgRetrieveLogFile, probe:6097
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    DATA #1 : String, 105 bytes
    Unexpected condition!!! Log chain ID from log file does not
    match the expected log chain ID for recovery.
    DATA #2 : unsigned integer, 4 bytes
    4
    DATA #3 : SQLPG_XHDR, PD_TYPE_SQLPG_XHDR, 2048 bytes
    Validity Check 1 = 9
    Format Version = 14
    xhdrAlVersion = V:11 R:1 M:4 F:4 I:a SB:0
    Log Extent State = 0x01038011
                                       - SQLPG_State_Init
                                       - SQLPG_State_Retrieved
                                       - SQLPG_State_Closed
                                       -
    SQLPG_State_FileEntryNum1_Valid
                                       -
    SQLPG_State_FileEntryNum2_Valid
                                       -
    SQLPG_State_Registration_Required
    Signature = IBMLOG
    Partition = 0
    Log Stream = 0
    Topology Life ID = 1441467570
    2015-05-13-03.39.30.000000 GMT
    Compression Mode = 0 (OFF)
    Segment Size = 0
    Extent Number = 142483
    Extent Size = 524288
    Number of Pages = 9288
    Previous Extent ID = 4294967295         SQLPG_IGNORE_PID
    Database Log ID = 1298725973
    2011-02-26-13.12.53.000000 GMT
    Current Extent ID = 1567032133
    2019-08-28-22.42.13.000000 GMT
    firstLso = 110789652322865 maps to 00006541CC1E4010
    minTruncOffset = 110789652322865
    fileEntryNum1 = 429751
    fileEntryNum2 = 429752
    logFileChainId = 5
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30257

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-12

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT30259

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021