IBM Support

IC74766: DB2 retrieve log code improved to verify correct logsize as per header and try second time to retrieve the log from TSM.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Upon making a log file retrieve attempt from TSM, db2 does not
    retry the retrieve if the retrieve failed, nor verify that the
    size of the log file retrieved is consistent with the expected
    size in the log file header.  This defect introduces logic to:
    verify the log files size matches the expected size; retry the
    retrieve exactly once if either the compared sizes do not match,
    or if there was an error retrieving the log file; inform the
    user via the diaglog that the retry was attempted and save the
    incorrect log file (if available) to the log file directory as
    well as issue diag warnings.  The second log file retrieved will
    also be saved if there is a size mismatch and diag log entries
    will be made.
    

Local fix

  • If the wrong sized tranaction log was previously retrieved and a
    correctly sized transaction log was archived successfully by
    TSM, use db2adutl to retrieve the correctly sized log.
    

Problem summary

  • DB2 retrieve log code improved to verify correct logsize as per
    log header and try second time again to retrieve the log from
    TSM if a mismatch occurs or an error is encountered retreiving
    the log file.
    

Problem conclusion

  • Fixed in V97 FP5
    

Temporary fix

  • If the wrong sized tranaction log was previously retrieved and a
    correctly sized transaction log was archived successfully by
    TSM, use db2adutl to retrieve the correctly sized log.
    

Comments

APAR Information

  • APAR number

    IC74766

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

  • Closed date

    2011-12-22

  • Last modified date

    2011-12-22

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

    IC74765

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

Modified date: 22 December 2011