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: [email protected]. 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 <[email protected]> Sent by: "ADSM: To Dist Stor [email protected] 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 [email protected] 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.
