DB2 FOR LUW / DB2FORLUW / A10 - 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 DB2 V10.1 users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 5 or higher.                   * 
****************************************************************

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).

Fixed in DB2 V10.1 Fix Pack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

17.10.2013
17.07.2015
17.07.2015