Database backup volumes not going away.

rdemaat

ADSM.ORG Member
Joined
Aug 19, 2008
Messages
92
Reaction score
1
Points
0
Hello all, I have a question about database backup volumes. This is for a TSM 5.5.6 system.

I do a q drmstatus and see this:

Recovery Plan Prefix: C:\DRPLAN\
Plan Instructions Prefix:
Replacement Volume Postfix: @
Primary Storage Pools:
Copy Storage Pools:
Not Mountable Location Name: NOTMOUNTABLE
Courier Name: COURIER
Vault Site Name: VAULT
DB Backup Series Expiration Days: 5 Day(s)
Recovery Plan File Expiration Days: 7 Day(s)
Check Label?: No
Process FILE Device Type?: No
Command File Name:



But I do a Q VOLH TYPE=DBB and see that the oldest version is dated 8/15/2013. Along with several others that are older than what DRMSTATUS says to keep. Partial list below:

Date/Time: 08/15/2013 05:03:40
Volume Type: BACKUPFULL
Backup Series: 2,819
Backup Operation: 0
Volume Seq: 1
Device Class: LTO4
Volume Name: AA2525L4
Volume Location: VAULT
Command:


This tape should have come back a while ago and been scratched and reused. Database backups are done almost every day.

What am I not doing? A DELETE VOLHISTORY? Something like DELETE VOLHISTORY TYPE=ALL TODATE=-8 ??? Should I do this every day?

And on a similar note. a Q VOLH shows the oldest entry is for a tape that has since been reused and has a newer entry in VOLH. I think thats normal but does the VOLH list need to go back so far? The DELETE VOLHISTORY probably would take care of this, correct?

Thank you!
 
Here's the Q DRM entry for the tape listed above.

AA2525L4 Vault 08/15/2013 07:08:02
 
Yes, expire runs maybe not daily but close.
 
The 'del volhist' command should indeed fix it. I always ran it in my environments even though I would have expected DRM to care of it.
eg:
DELETE VOLHISTORY TYPE=DBB TODATE=-5
DELETE VOLHISTORY TYPE=DBS TODATE=-5
 
The 'del volhist' command should indeed fix it. I always ran it in my environments even though I would have expected DRM to care of it.
eg:
DELETE VOLHISTORY TYPE=DBB TODATE=-5
DELETE VOLHISTORY TYPE=DBS TODATE=-5


If DRM is in use, delete volhistory is not recommended to be used. I never used delete volhistory when using DRM.
 
Ok. This is probably a real basic question but how do I know if DRM is in use? This may be related. This site has had some Korn shell scripts in place for a long time that do the daily TSM stuff. Some of them seem to be having problems lately. I dont know Korn very well. Hence, I've been running some of the daily things manually for a while. Maybe the DRM piece is part of what hasnt been working/running from these scripts.
 
Run 'q license' and look if you see this: Is Tivoli Storage Manager Extended Edition licensed: Yes
 
Yup. Here's the last few lines:

Number of TDP for WAS in use: 0
Number of TDP for WAS in try buy mode: 0
Is IBM System Storage Archive Manager in use ?: No
Is IBM System Storage Archive Manager licensed ?: No
Is Tivoli Storage Manager Basic Edition in use: Yes
Is Tivoli Storage Manager Basic Edition licensed: Yes
Is Tivoli Storage Manager Extended Edition in use: Yes
Is Tivoli Storage Manager Extended Edition licensed: Yes
Try-Buy Days Remaining:
Server License Compliance: Valid
 
Back
Top