DB2 FOR LUW / DB2FORLUW / 970 - DB2

Using the db2adutl tool to delete the logs older than the 
specified log, deletes the logs including the specified log as 
well. 
 
Specified log should be excluded from the deletion list. 
 
Here is an example: 
----------------------- 
$ db2adutl query db test 
Query for database TEST 
 
Retrieving FULL DATABASE BACKUP information. 
  No FULL DATABASE BACKUP images found for TEST 
<> 
Retrieving LOAD COPY information. 
  No LOAD COPY images found for TEST 
 
Retrieving LOG ARCHIVE information. 
   Log file: S0000000.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.29 
   Log file: S0000001.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.30 
   Log file: S0000002.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.30 
$ db2adutl delete logs older than S0000002.LOG without prompting 
 
Query for database TEST 
Retrieving LOG ARCHIVE information. 
   Log file: S0000000.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.29 
   Log file: S0000001.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.30 
   Log file: S0000002.LOG, Chain Num: 0, Log stream: 0, Taken 
at: 2013-12-03-17.20.30  <-- This log should not be included as 
we only want logs older than S0000002.LOG 
$ db2adutl query db test 
 
Query for database TEST 
Retrieving FULL DATABASE BACKUP information. 
  No FULL DATABASE BACKUP images found for TEST 
 
Retrieving LOG ARCHIVE information. 
+++++++++++++++++++++++++++++++++ 
 
Log file S0000002.LOG got deleted which should not be deleted.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users using TSM for log archiving.                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9 or Later.              * 
****************************************************************

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
 

First fixed in DB2 Version 9.7 Fix Pack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC98168 IC98173 
follow-up : 

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

14.03.2013
06.12.2013
06.12.2013

9.7.FP9