IBM Support

IC85449: LOG RETRIEVAL DOES NOT CHECK THE FORMAT VERSION AND CAN CAUSE ERROR DURING LATER CHECKING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When database starts retrieval of log we do not check the Format
    Version to make sure it is the same as the current.
    
    This can result in various error when we try and check the size
    of the log or further along, due to mismatch in the structures.
    
    The tool db2cklog should also check for this.
    
    db2diag.log:
    
    2012-04-19-12.45.30.158090+120 I134579A369        LEVEL: Warning
    PID     : 495636               TID  : 2571        PROC : db2sysc
    0
    INSTANCE: db2inst1 NODE : 000
    EDUID   : 2571                 EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogFile, probe:4130
    MESSAGE : Started retrieve for log file S0005686.LOG.
    
    2012-04-19-12.45.32.422286+120 E134949A611        LEVEL: Error
    PID     : 495636               TID  : 2571        PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 2571                 EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogVendor, probe:2516
    DATA #1 : String, 107 bytes
    The actual log file size did not match the expected file size,
    retrying retrieve. Actual / Expected / File:
    DATA #2 : signed integer, 8 bytes
    1245184
    DATA #3 : signed integer, 8 bytes
    8192
    DATA #4 : String, 51 bytes
    /ap/fh/fhdba03/fh0310bh/sqlog/NODE0000/S0005686.TMP
    
    2012-04-19-12.45.32.422678+120 E135561A562        LEVEL: Error
    PID     : 495636               TID  : 2571        PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 2571                 EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogVendor, probe:2533
    MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already
    exists"
              DIA8722C A file already exists.
    DATA #1 : String, 107 bytes
    An error was encountered moving the mismatched sized logfile to
    a saved file on the first retrieve attempt.
    
    2012-04-19-12.45.32.422976+120 I136124A606        LEVEL: Warning
    PID     : 495636               TID  : 2571        PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 2571                 EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogVendor, probe:2697
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    DATA #1 : String, 84 bytes
    An error was encountered in first retrieve attempt. Retry will
    be attempted.  errId:
    DATA #2 : signed integer, 8 bytes
    3778
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 Fixpack 7 or Higher                          *
    ****************************************************************
    

Problem conclusion

  • First Fixed in v9.7 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85449

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

  • Closed date

    2012-10-30

  • Last modified date

    2012-10-30

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

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

    IC88339

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

Modified date: 30 October 2012