You don't need to keep the STGNEW, STGREUSE, STGDELETE records any longer than your oldest DBBACKUP - and even the recent ones are only useful in very arcane cases for documentation if you have to do a DBRESTORE and subsequent audits. TSM doesn't need or use the STGNEW, STGREUSE, or STGDELETE records for anything, even if the tapes described by them are still in a stgpool.
As Mark said, set up an admin schedule or script that runs daily or weekly to purge them. I personally don't recommend doing a delete TYPE=ALL, however. If somebody creates a BACKUPSET or EXPORT tape, those will get zapped by a DELETE VOLHIST TYPE=ALL as well. So I prefer doing the automated DELETE VOLHIST for exactly the things I know for sure I want deleted. Wanda Prather "I/O, I/O, It's all about I/O" -(me) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ken Chamberlain Sent: Wednesday, March 07, 2007 11:39 AM To: [email protected] Subject: volume history file I've been running TSM for over a decade now. During this time the only deletions from volhist happen by way of a daily schedule: "del volhist todate=today-9 type=dbb" My volhist file is getting HUGE. There must be more I can delete. What do other shops do? How do you find the oldest inuse volume? I tried querying the volume table for LAST_WRITE_DATE and sorting ascending on this column, the first record is the oldest tape. Do I then find this volumes entries in volhist to find its current creation date (STGNEW)? Ken Chamberlain University of Toronto Phone:(416) 978-1582 Fax: (416) 971-2085 E-mail: [EMAIL PROTECTED]
