ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [ADSM-L] SQL SELECT to show what's mounted and why

2009-02-13 07:22:41
Subject: Re: [ADSM-L] SQL SELECT to show what's mounted and why
From: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 13 Feb 2009 07:20:53 -0500 
I don't know of a simple way to get a overview of tape drive activity from
TSM, especially if you have a library sharing environment and storage
agents.  Frustrated, I wrong a script to give an overview.  Below is a
sample run of the script.

If you'd like a copy, shoot me an email:  rrhodes AT firstenergycorp DOT com.



rsfebkup4p:/tsmdata/tsm_scripts==>./q_tape_drive_status.ksh


==  200902130711

==  library  drive  online paths(total/online/offline)  state  allocated_to
volume_name  process/session

 3584GO 3584GO-F01R01 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R02 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R03 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R04 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R05 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R06 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R07 YES 6/6/0 LOADED TSM2 J02688    PROCESS= 9835 Backup
Storage Pool
 3584GO 3584GO-F01R08 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R09 YES 6/6/0 EMPTY
 3584GO 3584GO-F01R0A YES 6/6/0 EMPTY
 3584GO 3584GO-F01R0B YES 6/6/0 LOADED TSM2 J04321    PROCESS= 9832 Backup
Storage Pool
 3584GO 3584GO-F01R0C YES 6/6/0 EMPTY
 3584GO 3584GO-F03R01 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R02 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R03 YES 24/24/0 LOADED TSMSAP1 J03962    PROCESS= 1775
Migration
 3584GO 3584GO-F03R04 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R05 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R06 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R07 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R08 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R09 YES 24/24/0 EMPTY
 3584GO 3584GO-F03R0A YES 24/24/0 EMPTY
 3584GO 3584GO-F03R0B YES 24/24/0 EMPTY
 3584GO 3584GO-F03R0C YES 24/24/0 EMPTY
 3584GO 3584GO-F04R01 YES 24/24/0 EMPTY
 3584GO 3584GO-F05R01 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R02 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R03 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R04 YES 6/6/0 LOADED TSM2 J00506    PROCESS= 9833 Backup
Storage Pool
 3584GO 3584GO-F05R05 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R06 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R07 YES 6/6/0 LOADED TSM2 J00428    PROCESS= 9837 Backup
Storage Pool
 3584GO 3584GO-F05R08 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R09 YES 6/6/0 EMPTY
 3584GO 3584GO-F05R0A YES 6/6/0 EMPTY
 3584GO 3584GO-F05R0B YES 6/6/0 LOADED TSM2 J04535    PROCESS= 9834 Backup
Storage Pool
 3584GO 3584GO-F05R0C YES 6/6/0 EMPTY
 3584GO 3584GO-F06R01 YES 6/6/0 EMPTY
 3584GO 3584GO-F06R02 YES 6/6/0 EMPTY
 3584GO 3584GO-F06R03 YES 6/6/0 EMPTY
 3584GO 3584GO-F06R04 YES 6/6/0 LOADED TSM2 J03893    PROCESS= 9836 Backup
Storage Pool
 3584GO 3584GO-F06R05 YES 6/6/0 EMPTY
 3584GO 3584GO-F06R06 YES 6/6/0 EMPTY
 3584GO 3584GO-F06R07 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R01 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R02 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R03 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R04 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R05 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R06 YES 6/6/0 LOADED TSM1 J02017    PROCESS= 7854
Backup Storage Pool
 3584ISOC 3584ISOC-F01R07 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R08 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R09 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R0A YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R0B YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F01R0C YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F03R01 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R02 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R03 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R04 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R05 YES 24/24/0 LOADED STASAPEQ2D1 J03473    SESSION=
955  SAPEQ2D1_DB
 3584ISOC 3584ISOC-F03R06 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R07 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R08 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R09 YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R0A YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R0B YES 24/24/0 EMPTY
 3584ISOC 3584ISOC-F03R0C YES 24/24/0 LOADED STASAPEQ2D1 J03105    SESSION=
946  SAPEQ2D1_DB
 3584ISOC 3584ISOC-F04R01 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R02 YES 6/6/0 LOADED TSM1 J02147    PROCESS= 7852
Backup Storage Pool
 3584ISOC 3584ISOC-F04R03 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R04 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R05 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R06 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R07 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R08 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R09 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R0A YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R0B YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F04R0C YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R01 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R02 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R03 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R04 YES 6/6/0 LOADED TSM1 J02076    PROCESS= 7851
Backup Storage Pool
 3584ISOC 3584ISOC-F05R05 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R06 YES 6/6/0 LOADED TSM1 J00805    PROCESS= 7855
Backup Storage Pool
 3584ISOC 3584ISOC-F05R07 YES 6/6/0 EMPTY
 3584ISOC 3584ISOC-F05R08 YES 6/6/0 LOADED TSM1 J02026    PROCESS= 7853
Backup Storage Pool
 3584ISOC 3584ISOC-F05R09 YES 6/6/0 EMPTY

=== lib  drives_loaded  drives_not_loaded
=== 200902130711   3584isoc 5 28   3584isocSAP 2 10   3584go 6 25
3584goSAP 1 12      unknown 0



rsfebkup4p:/tsmdata/tsm_scripts==>




             Roger Deschner
             <rogerd AT UIC DOT EDU>
             Sent by: "ADSM:                                            To
             Dist Stor                 ADSM-L AT VM.MARIST DOT EDU
             Manager"                                                   cc
             <[email protected]
             .EDU>                                                 Subject
                                       SQL SELECT to show what's mounted
                                       and why
             02/12/2009 01:18
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






I'm looking for an SQL SELECT that will display a list of what tape is
mounted on each drive, and which session or process it's mounted for.

I've looked at SHOW ASMOUNTED, SHOW ASVOL, SHOW MP and they don't really
do it.

I'm dealing with a drive-constrained system and no budget to add
drives, so I'm trying to manage the situation with better automation.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
               Academic Computing & Communications Center
======I have not lost my mind -- it is backed up on tape somewhere.=====



-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [ADSM-L] [OFFTOPIC] Announce online generator for LTO barcode labels, PAC Brion Arnaud
Next by Date:  Re: [ADSM-L] TSM v6 -announcement, Andrew Raibeck
Previous by Thread:  Re: [ADSM-L] SQL SELECT to show what's mounted and why, Colwell, William F.
Next by Thread:  Re: [ADSM-L] SQL SELECT to show what's mounted and why, Roger Deschner
Indexes:  [Date] [Thread] [Top] [All Lists]