Hello Dale,
I had a similar requirement at American Express (to track drive
utilizations of 3494 ATLs). I realize the following does not track
individual drives, but I found this quite useful. I used the following
SQL query (imbedded in a korn shell script) to sum the total mount time
for the previous 24 hours:
"select sum(cast((end_time-start_time)seconds as integer)/60) from
summary where cast((current_timestamp-start_time)seconds as integer) <
86400 and activity='TAPE MOUNT'"
This query calculates the total number of minutes tapes were mounted in
the drives. Then I multiplied the total number of drives by the total
number of minutes in a day:
tot_mins=$num_drvs*1440
Finally, I multiplied the total number of minutes tapes were mounted by
100 and divided by the total possible mount minutes to derive the
percent utilized of the environment.
drv_util=$num_mins*100/$tot_mins
Note - the mount time also includes the "lag" of the mount retention.
This is the delay after which the TSM process is complete and the tape
is actually dismounted. At AMEX we had mount retetion set to 10 minutes
(60 is the default).
If your TSM server gets above 50 percent, it's busy. Also - if you need
to track individual drives, the Ces may be able to parse the 3494 drive
logs, but I think that's a bit cumbersome.
Hope this helps.
Regards,
- Paul
Paul Thorson
Levi, Ray & Shoup, Inc.
Tivoli Specialist - LRS IT Solutions
(217) 793-3800 x1704
-----Original Message-----
From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
Sent: Monday, September 09, 2002 7:44 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 3494 Utilization
In the long run, we are attempting to quantify exactly how "busy" our
ATLs/drives are over time for a number of reasons -- capacity planning,
adjusting schedules to better utilize resources, and possibly even
justify the purchase of new tape drives.
At this point I have been asked to simply come up with a minutes or
hours per 24 hour period any particular drive is in use.
A "query mount" every minute might work, but it just isn't a good
solution for two reasons -- for clients writing directly to tape, the
mounted tape won't show up in "query mount", and most of these servers
already have an extensive number of scripts accessing them periodically
for various monitoring and reporting functions - I hesitate to add any
more to them.
My last resort is going to be to extract the activity log once every 24
hours and examine the logs and match the mount/dismounts by drive and
attempt to calculate usage that way if there isn't something better.
With the difficulty in matching mounts to dismounts, I'm not entirely
convinced it's worth the trouble.
-----Original Message-----
From: Mr. Lindsay Morris [mailto:lmorris AT servergraph DOT com]
Sent: Friday, September 06, 2002 4:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 3494 Utilization
If you use the atape device driver, you (supposedly) can turn on logging
within it. Then every dismount writes a record of how many bytes were
read/written during that mount. Never tried it ... if you can get it
working, let me know how, please! We'd love to be able to do that.
Right now we CAN show you library-as-a-whole data rates, just by
layering all the tape-drive-writing tasks (migration, backup stgpool,
backup DB, etc) one atop the other minute by minute. Maybe that's
enough - why do you need drive-by-drive data rates?
---------------------------------
Mr. Lindsay Morris
CEO, Servergraph
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 Jolliff, Dale
> Sent: Friday, September 06, 2002 2:16 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: 3494 Utilization
>
>
> Paul said that Servergraph has this functionality - According to our
> hardware guys, the 3494 library has some rudimentary mount statistics
> available.
>
> I'm going to be looking into both of those options.
>
> Surely someone has already invented this wheel when trying to justify
> more tape drives - other than pointing to the smoke coming from the
> drives and suggesting that they are slightly overused....
>
>
>
>
>
> -----Original Message-----
> From: Cook, Dwight E [mailto:DWIGHT.E.COOK AT SAIC DOT COM]
> Sent: Friday, September 06, 2002 6:45 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: 3494 Utilization
>
>
> Good question, never actually thought about it...
> I would think that the sum of the difference between mount & dismount
> times for each drive...
> OH THANKS..... now I won't be able to sleep until I code some select
> statement to do this :-(
> if I figure it out, I'll pass it along
>
> Dwight
>
>
>
> -----Original Message-----
> From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
> Sent: Thursday, September 05, 2002 10:04 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: 3494 Utilization
>
>
> I saw this topic out on ADSM, and I could not locate any type of
> functional resolution ...
>
> What is everyone using to calculate the "wall time" of your tape drive
> utilization?
>
|
