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