DB2 FOR LUW / DB2FORLUW / 950 - DB2

An Incremental Automatic Restore on DB2 Version 9.5 FP9 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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 10.                      * 
****************************************************************

First fixed in DB2 Version 9.5 Fix Pack 10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.04.2012
18.10.2013
18.10.2013

9.5.FP10