DB2 FOR LUW / DB2FORLUW / A50 - DB2

db2 "prune history yyyymmddhhmmss and delete" is deleting 
necessary LOG. 
 
db2 list history backup all for db sample | grep  " B " 
  B  D  20140618144208001   F    N  S0000000.LOG S0000000.LOG 
  B  D  20140618145059001   N    D  S0000000.LOG S0000000.LOG 
  B  D  20140618145214001   N    D  S0000001.LOG S0000001.LOG 
 
db2 list history archive log all for db sample | grep  " X " 
  X  D  20140618145101      1    D  S0000000.LOG C0000000 
  X  D  20140618145101      1    D  S0000001.LOG C0000000 
  X  D  20140618145217      P    D  S0000002.LOG C0000000 
 
 
specify 20140618145216(Between last backup date 20140618145214 
and last archived date 20140618145217) in prune history and 
delete 
db2 prune history 20140618110156 and delete 
 
$ db2 connect to sample 
 
   Database Connection Information 
 
 Database server        = DB2/AIX64 10.1.2 
 SQL authorization ID   = DB2INST1 
 Local database alias   = SAMPLE 
 
$ db2 prune history 20140618145216 and delete 
DB20000I  The PRUNE command completed successfully. 
$ db2 list history backup all for db sample | grep  " B " 
  B  D  20140618145214001   N    D  S0000001.LOG S0000001.LOG 
$ db2 list history archive log all for db sample | grep  " X " 
  X  D  20140618145217      1    D  S0000002.LOG C0000000 
 
db2 deleted S0000001.LOG. 
So, DB2 can not restore backup due to lack of LOG file.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 UDB version 10.5 fixpack 7.                      * 
****************************************************************

Use LOGFILE PRIOR TO instead of history yyyymmddhhmmss and 
delete.

Problem was first fixed in DB2 UDB Version 10.5 Fixpack 7.

keiner bekannt / siehe Local-Fix

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

22.07.2014
20.01.2016
20.01.2016