Thanks for the response, I would like to determine what volumes to go to overflow - based upon oldest last use date I think) so I can make sure I have 20 scratch daily or 60 for the weekend.
>>> [EMAIL PROTECTED] 11/24/2003 11:09:07 AM >>> Paul, Please elaborate on what you mean by 'determine what tapes to send for temp onsite storage'. I'm a bit confused... To make sure you have enough scratch tapes in your library a simple SQL query might help: select status, last_use, count(*) from libvolumes group by last_use, status For load, I have set up a Windows scheduled task that uses the admin command line interface to perform a few queries and append the results to a file. This is helpful to determine how many drives are in use, how many client tasks are active, how many processes are running, etc at any given interval. Reviewing this file can be helpful to look in the rear view mirror to see what might have happened. You could also use the TSM activity log and extract related messages, but the activity log doesn't nicely show how many tape drives you have in use! John G. Talafous IS Technical Principal The Timken Company Global Software Support P.O. Box 6927 Data Management 1835 Dueber Ave. S.W. Phone: (330)-471-3390 Canton, Ohio USA 44706-0927 Fax : (330)-471-4034 [EMAIL PROTECTED] http://www.timken.com ********************************************************************** PLEASE NOTE: The above email address has recently changed from a previous naming standard -- if this does not match your records, please update them to use this new name in future email addressed to this individual. This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **********************************************************************
