The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it.
SELECT * from volumes where volume_name='vvvvvv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
