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:Thomas.Walker AT EMICAP DOT COM]
Sent: Friday, September 20, 2002 12:31 PM
To: ADSM-L AT VM.MARIST DOT EDU
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