Here's what I do from a ksh script . . .
/usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337
begint=00:00 begind=-1 endd=-1 endt=23:59 | \
/usr/bin/grep -c ANR8337
This gives me a count of the number of tape mounts yesterday. I
execute this script, log the output to a file, and then generate a graph
using gnuplot to show the drive mounts over time.
Mahesh
>>> [EMAIL PROTECTED] 09/20/02 01:36PM >>>
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
