delete volhist type=all todate=today-(however many days you want to keep)
 
This should be run as an administrative schedule every day.
 
--
Mark Stapleton (mark.s AT evolvingsol DOT com)
Senior consultant

________________________________

From: ADSM: Dist Stor Manager on behalf of Ken Chamberlain
Sent: Wed 3/7/2007 10:38 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [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