How to use Db2adutl delete logs

09 May,2012 by Jack Vamvas

Question:  How can I  delete old archive  logs from Tivoli Storage Manager (TSM) ?

I’ve confirmed the TSM backup client configuration for DB2 on Linux is all OK

Answer:  The db2adutl  command comes with DB2.  The tool is located in the $HOME/sqllib/adsm directory of the instance owner.  You can extract, loadcopies, verify backups , query and delete from TSM.

The backup copies in TSM  always active and never deleted by normal TSM file expiration processing. The db2adutl utility provides a way of deleting backups and log files that are no longer required

This example code demonstrates the delete  archive logs functionality

db2adutl delete logs between S0003838.LOG and S0003840.LOG db 

 When this command executes places a flag next to the object references within the TSM DB and the Expiration process on the TSM Server will then remove these references when it runs each day.

Read More

DB2 and TSM Cross-node recovery - DBA DB2

DB2 – Backup history

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to use Db2adutl delete logs

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright