DB2 FOR LUW / DB2FORLUW / 970 - DB2

Auto deletion of backup objects is enabled via the 
AUTO_DEL_REC_OBJ db cfg parameter. 
 
When changing from archival logging to circular logging ( and 
back as needed ), it is possible log this auto deletion will 
stop working. 
This is triggered by the fact that  the log file sequence in the 
history files gets reset, so the log file numbers will start 
back at 0. 
 
This can cause the prune history logic to become confused and 
set the timestamp from where to prune backup images back at the 
beginning of the history file, thereby failing to prune images 
that should be removed.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to V9.7 Fix Pack 9               * 
****************************************************************

As a workaround, the entries to be pruned can manually be 
updated using the "UPDATE HISTORY" command and changing 
the obsolete history entries from 'A' (active) to 'D' (delete).

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem has first been fixed in v9.7 Fix Pack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC96961 IT03081 
follow-up : 

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

06.08.2013
26.06.2014
26.06.2014

9.7.FP9