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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ken Chamberlain
Sent: Wednesday, March 07, 2007 11:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
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: ken.chamberlain AT utoronto DOT ca