IBM Support

IC78257: Incremental Automatic Restore on DB2 Version 9.7 may fail with SQL2571N Reason Code 3

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • An Incremental Automatic Restore on DB2 Version 9.7 may fail
    with SQL2571N Reason Code 3.
    
    Here is an example on that:
    
    $ db2_all "<<+0< db2 restore db SAM incremental automatic from
    /test/backup taken at 20110726092149 INTO SAM REPLACE HISTORY
    FILE Replace Existing without prompting"
    
    SQL2571N An automatic restore is unable to proceed. Reason code:
    "3".
    x336solaris1: db2 restore db SAM ... completed rc=4
    
    Entries on db2diag.log will show something like the following:
    
    DATA #1 : String, 126 bytes
    During verification, missing required backup image was noticed
    for tablespace SYSCATSPACE. Tablespace was in search state I.
    
    This APAR intends to solve this problem.
    

Local fix

  • Run a manual incremental restore instead of automatic as a
    workaround for this issue
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * N/A                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * An Incremental Automatic Restore on DB2 Version 9.7 may fail *
    * with SQL2571N Reason Code 3.                                 *
    *                                                              *
    * Here is an example on that:                                  *
    *                                                              *
    * $ db2_all "<<+0< db2 restore db SAM incremental automatic    *
    * from                                                         *
    * /test/backup taken at 20110726092149 INTO SAM REPLACE        *
    * HISTORY                                                      *
    * FILE Replace Existing without prompting"                     *
    *                                                              *
    * SQL2571N An automatic restore is unable to proceed. Reason   *
    * code:                                                        *
    * "3".                                                         *
    * x336solaris1: db2 restore db SAM ... completed rc=4          *
    *                                                              *
    * Entries on db2diag.log will show something like the          *
    * following:                                                   *
    *                                                              *
    * DATA #1 : String, 126 bytes                                  *
    * During verification, missing required backup image was       *
    * noticed                                                      *
    * for tablespace SYSCATSPACE. Tablespace was in search state   *
    * I.                                                           *
    *                                                              *
    * This APAR intends to solve this problem.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 Fix Pack 5                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC78257

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-22

  • Closed date

    2011-12-23

  • Last modified date

    2011-12-23

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

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78257

Modified date: 23 December 2011