DB2 FOR LUW / DB2FORLUW / A50 - DB2

An online backup may trigger auto prune to delete the first log 
required 
by the oldest backup image that needs retaining. 
 
In case where the customer sets auto_del_rec_obj on and 
configures num_db_backups and rec_his_retentn, when 
backup-initiated atuo-prune starts to run, if the number of 
backups reaches num_db_backups and the oldest backup that needs 
retaining is an online backup but not rec_his_retentn (in our 
repro, we set it to 2) days old yet, auto-prune will mistakenly 
delete the first log required by this oldest online backup if 
that first log is over rec_his_retentn days old. 
 
The following is the repro: 
 
auto_del_rec_obj ON 
num_db_backups   2 
rec_his_retentn  3 
 
 
In the history file, 
 
Before back-initiated auto prune starts, we have the following: 
 
log file 1 
 
backup 1 
 
log file 2 (over 3 days old and is the first log required by 
backup 2) 
 
log file 3 
 
backup 2   (less than 3 days old and is online backup and the 
first required log file is log file 2) 
 
backup 3 
 
 
 
After the auto prune, we will end up with the following, that 
is, we mistakenly delete the log file required by backup 2. 
 
log file 3 
 
backup 2   (less than 3 days old and is online backup and the 
first required log file is log file 2) 
 
backup 3

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

Can look to reduce REC_HIS_RETENTN.

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

09.06.2017
29.09.2017
29.09.2017

9.0.