If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Expiring log files from TSM?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-09-03, 11:20
ksimpson ksimpson is offline
Registered User
 
Join Date: May 2003
Posts: 10
Expiring log files from TSM?

Informational tokens are "DB2 v8.1.0.24", "s030728", "U488482", and FixPak "3". on Solaris 2.8

As someone new to DB2 UDB I'm still trying to get my hands around a backup and recovery strategy. I'll be backing up the database online to TSM and know I can use the supplied user exit for copying the archived log files to TSM. My question is what is the process/best practice for expiring the old archive logs out of TSM when they are no longer needed?

For example, if I use db2adutl to delete all full backups older than 14 days and now my oldest log is now S0006157.LOG, how do I tell TSM to expire anything prior to S0006157.LOG? Is there an automated way?

TIA

Ken
Reply With Quote
  #2 (permalink)  
Old 12-09-03, 13:00
GertK GertK is offline
Registered User
 
Join Date: Nov 2003
Location: Netherlands
Posts: 96
Re: Expiring log files from TSM?

Quote:
Originally posted by ksimpson
Informational tokens are "DB2 v8.1.0.24", "s030728", "U488482", and FixPak "3". on Solaris 2.8

As someone new to DB2 UDB I'm still trying to get my hands around a backup and recovery strategy. I'll be backing up the database online to TSM and know I can use the supplied user exit for copying the archived log files to TSM. My question is what is the process/best practice for expiring the old archive logs out of TSM when they are no longer needed?

For example, if I use db2adutl to delete all full backups older than 14 days and now my oldest log is now S0006157.LOG, how do I tell TSM to expire anything prior to S0006157.LOG? Is there an automated way?

TIA

Ken
You should use the db2adutl delete logs between ... command to delete them. There might be users around who have created a script for this already.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On