We do a selective delete of history file records by type.
Once I exported a node to tape and wanted to keep it for some time.
With "delete volhistory type=all" I've lost this information after just a 
couple of days.
So do yourself a favour and define what you want to delete. Create a Server 
Command
Script and define an Administrative command schedule to run it.

HTH
Thomas Rupp 

-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Ken Chamberlain
Gesendet: Mittwoch, 07. März 2007 17:39
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: [ADSM-L] 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