For what its worth, this is one of the reports that I run daily to check on my tape usage. You will probably have to change the device class. This script is based on some code that a fellow ADSMer shared with me a while ago. I have developed a number of scripts and would be pleased to share.. a list appears below...
All the best Tony Morgan ---------------------------------------------------------------------------- ------------------- /* Tony Morgan : Last Chg February 2002 : Tapes Report */ select access as "Access (All Tapes)", count(*) as "# Tapes" from volumes where devclass_name='DLT35C' group by access select status as "Status (Tapes in Library)", count(*) as "# Tapes" from libvolumes group by status select stgpool_name as "StgPool Name", status as "Status", count(*) as "# Tapes" from volumes where devclass_name='DLT35C' group by stgpool_name, status select stgpool_name as "Private StgPools", count(*) as "# Empty Tapes" from volumes where status='EMPTY' and devclass_name='DLT35C' group by stgpool_name select volume_name as "Empty Tapes", stgpool_name as "StgPool" from volumes where status='EMPTY' and devclass_name='DLT35C' select volume_name as "Scratch Tapes" from libvolumes where status='Scratch' q vol dev=DLT35C q mount ---------------------------------------------------------------------------- ------------------- Script Name: ALLOCC Description: Occupancy File Statistics by Node Name Script Name: BACKUP_STATUS Description: Query Last Backup status Script Name: CACHE Description: Cache Statistics Script Name: CHECKIN Description: Checkin all labellled tapes in the mailbox Script Name: DB Description: Database Info Script Name: DBBACKUP Description: Backup DB on request to Disk Script Name: DBBACKUP_TAPE Description: Backup DB on request to Tape Script Name: DBCHECK_DAILY Description: Check DB Report Script Name: FILESPACE Description: Filespace Check Script Name: FILE_STATS Description: Occupancy File Statistics by Node Name Script Name: LOST_FILE Description: Find what volume a file is on Script Name: MOUNTS Description: Count Weekly Tape Mounts Script Name: OCC_REP Description: Occupancy File Statistics by Node Name Script Name: S01T Description: List sessions since yesterday Script Name: SCRIPTS Description: List all command scripts - This report! Script Name: SESSIONS Description: List sessions since yesterday Script Name: SLOTS Description: What Tape is in each Slot? (Adic Scalar100) Script Name: SUMMARY Description: Summary Report Script Name: TAPES Description: Query Known Tapes Script Name: TAPES_2 Description: ServerTapePool % of Capacity In Use Script Name: TAPLAB Description: Label all unknown tapes by barcode -----Original Message----- From: Thomas Denier [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 15:22 To: [EMAIL PROTECTED] Subject: tape management > Does anyone know of any tape management systems for tsm? Or how do most > people track scratch tapes and how do you know how many scratch tapes will > be needed??? Any help would be great What platform will your TSM server run on? Different implementations take very different approaches to tape management. In particular, the Unix and Windows implementations mostly do their own tape management, while the OS/390 implementation mostly leaves tape management to the operating system. ============================================================ This e-mail and any files transmitted with it, are confidential and intended solely for the use of the addressee. The content of this e-mail may have been changed without the consent of the originator. The information supplied must be viewed in this context. If you have received this e-mail in error please notify our Helpdesk by telephone on +44 (0) 20-7444-8444. Any use, dissemination, forwarding, printing, or copying of this e-mail or its attachments is strictly prohibited.
