How to delete old db backups

koda

ADSM.ORG Member
Joined
Sep 29, 2005
Messages
29
Reaction score
0
Points
0
Hi all

i have autoloader with 8 slot

and daily schedule for tsm db backup.



now my situation is



tsm: SERVER1>q libvol



Library Name Volume Name Status Owner Last Use Home Device

Element Type

------------ ----------- ---------- ---------- --------- ------- ------

IBM MEDIA1 Private Data 1

IBM MEDIA2 Private Data 3

IBM MEDIA3 Private Data 4

IBM MEDIA4 Private DbBackup 5

IBM MEDIA5 Private DbBackup 6

IBM MEDIA6 Private DbBackup 7tsm: SERVER1>delete volh t=dbb tod=today-1

IBM MEDIA7 Private DbBackup 2



i've try to delete old backup using delete volhist with no result



Do you wish to proceed? (Yes (Y)/No (N)) y

ANR2467I DELETE VOLHISTORY: 0 sequential volume history entries were

successfully deleted.

tsm: SERVER1>q volhist t=dbb



Date/Time: 06/27/2006 18:53:12

Volume Type: BACKUPFULL

Backup Series: 1

Backup Operation: 0

Volume Seq: 1

Device Class: LTOCLASS

Volume Name: MEDIA7

Volume Location:

Command:



Date/Time: 06/28/2006 17:28:28

Volume Type: BACKUPINCR

Backup Series: 1

Backup Operation: 1

Volume Seq: 1

Device Class: LTOCLASS

Volume Name: MEDIA4

Volume Location:

Command:



Date/Time: 06/29/2006 08:00:07

more... (<ENTER> to continue, 'C' to cancel)



Volume Type: BACKUPINCR

Backup Series: 1

Backup Operation: 2

Volume Seq: 1

Device Class: LTOCLASS

Volume Name: MEDIA5

Volume Location:

Command:



Date/Time: 06/30/2006 08:00:23

Volume Type: BACKUPINCR

Backup Series: 1

Backup Operation: 3

Volume Seq: 1

Device Class: LTOCLASS

Volume Name: MEDIA6

Volume Location:

Command:



how i can keep just one copy of db backup?

thanks
 
Koda,

You have several incrementals dependent on the full. Create a full backup and then you should be able to delete the others. You may find it simpler to manage if you always do a full backup rather than the full/incremental routine.



Cheers,

Neil
 
Back
Top