Paul,
I recently needed this same info, so I wrote a Rexx program to take the results of a
TSM SQL command and use the data to graphically plot tape drive utilization for all
drives across a given span of time. Although we use Aix for our TSM server, the Rexx
program runs on our OS/390 mainframe. If you are interested, reply direct to me and I
can send you the jcl, rexx code, etc. The program is < 200 lines, but makes heavy use
of dynamic, multi-dimensional arrays, so you would need to be fairly proficient in
Rexx to do much de-coding.
Steve Schaub
Haworth, Inc
email: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 04/25 12:51 PM >>>
Paul,
I tried:
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.mount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8337
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.dismount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8468
I then opened both files with Excel, set it to delimited by comma and space,
then deleted all the columns I didn't need, copied one file and pasted on
the end of the other, and sorted by drive then date/time, and came up with
the following (just an exerpt, of course). This took about 5 minutes.
4/24/01 15:30 102200 mounted rmt1
4/24/01 15:37 102200 dismounted rmt1
4/24/01 20:55 100702 mounted rmt1
4/24/01 21:17 100702 dismounted rmt1
4/24/01 15:28 102074 mounted rmt10
4/24/01 15:30 102074 dismounted rmt10
4/24/01 15:37 101222 mounted rmt11
4/24/01 15:38 101222 dismounted rmt11
If you need to automate it, this may be doable with SQL and it'd definitely
be doable with AWK, and PERL. Maybe SED.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
-----Original Message-----
From: paul baines [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 8:27 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone have any SQL ideas for these stats?
This is cool. But only works in 4.1.x (4.1.2.0) and not in 3.7.3.0 for me.
And most of my servers are still 3.7.
>This might get you some useful information
>from TSM about tape mounting activity:
>
>tsm> select * from summary where activity='TAPE MOUNT'
> START_TIME: 2001-03-26 00:01:00.000000
> END_TIME: 2001-03-26 00:12:30.000000
> ACTIVITY: TAPE MOUNT
> NUMBER: 0
> ENTITY:
> COMMMETH:
> ADDRESS:
>SCHEDULE_NAME:
> EXAMINED: 0
> AFFECTED: 0
> FAILED: 0
> BYTES: 0
> IDLE: 0
> MEDIAW: 0
> PROCESSES: 0
> SUCCESSFUL: YES
> VOLUME_NAME: 065643
> DRIVE_NAME: DRIVE33 (/dev/rmt/33st)
> LIBRARY_NAME: LIB22
> LAST_USE: Data
>
>
>
>
>
>Richard Sims <[EMAIL PROTECTED]> on 04/25/2001 09:32:50 AM
>
>Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
>To: [EMAIL PROTECTED]
>cc: (bcc: Matthew Glanville/437358/EKC)
>Subject: Re: Anyone have any SQL ideas for these stats?
>
>
>
>
> > I need to see if I can determine:
> > - # of mounts per individual tape drive
> > - drive useage - would like to be able to compare when all drives
> >are in use, for how long, etc,
>
>Harold - I'm not aware that TSM tracks such information; but advanced
> tape drives like the 3590 themselves record such information,
>internally...
>
>You can use the 3590 front panel to get mount information from the
>Show Statistics menu. Refer to the 3590 Operator Guide.
>
>You can typically ask various types of tape drives for the counters that
>they
>maintain. For the 3590 you can get statistics such as Drive Lifetime
>Mounts,
>Drive Lifetime Megabytes Written or Read, from the Log Page X'3D'
>(Subsystem
>Statistics), via discrete programming or with the 'tapeutil' command, like:
>
> tapeutil
>
> Enter Selection: 1
>
> Enter the device special file name (Example: /dev/rmt0): /dev/rmt3
>
> Select mode (1=Read/Write, 2=Read Only, 3=Write Only, 4=Append): 2
>
> Opening device...
>
> Enter Selection for /dev/rmt3: 9
>
> Enter page code in hex: 3d
>
> Enter parameter pointer in hex or <enter> for all parameters: 40
>
> Enter length (including header) or <enter> for entire parameter:
> Issuing log sense for page 0x3D...
>
> Log Sense Page 0x3D, Page Length 28, Data, Length 28
>
> 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF
> 0000 - 3D00 0018 0040 6004 0000 066A 0041 6004 [=....@`....j.A`.]
> 0010 - 0015 63E3 0042 6004 0011 F9D6 [..cc.B`...yV ]
>
>Refer to the 3590 Hardware Reference manual for codes and byte positions.
>Here, we requested 40, being Drive Lifetime Mounts. That returned
>the 32-bit value 0000066A, or 1642 decimal. The parameter 41 Drive
>Lifetime
>Megabytes Written happens to be returned as well: 001563E3, or 1,401,827
>MB.
>
> Richard Sims, BU
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
