ADSM-L

Re: SQL to find # of mounts for tapes?

2002-09-20 14:41:17
Subject: Re: SQL to find # of mounts for tapes?
From: "Mr. Lindsay Morris" <lmorris AT SERVERGRAPH DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 20 Sep 2002 14:37:08 -0400
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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Mahesh Tailor
> Sent: Friday, September 20, 2002 2:11 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
>
> >>> seay_pd AT NAPTHEON DOT COM 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: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
>

<Prev in Thread] Current Thread [Next in Thread>