We do someting similar, but we analyze all of the 50-or-so messages that pertain to drive mounts, and come up with the percent of time mounted during the day. That feeds into capacity planning - you can predict, with a wekk or two of history, when your library is going to be 100% utilized.
--------------------------------- Mr. Lindsay Morris Lead Architect, Servergraph/TSM www.servergraph.com 859-253-8000 ofc 425-988-8478 fax > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Mahesh Tailor > Sent: Friday, September 20, 2002 2:11 PM > To: [EMAIL PROTECTED] > Subject: Re: SQL to find # of mounts for tapes? > > > 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 >
