Have you considered the SUMMARY table. The is are columns for ACTIVITY
(Session or Process) and VOLUME_NAME. I have not tried to build
anything like that, but it could be interesting.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Deschner
Sent: Thursday, February 12, 2009 1:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL SELECT to show what's mounted and why
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.=====
IMPORTANT: E-mail sent through the Internet is not secure and timely delivery
of Internet mail is not guaranteed. Legg Mason therefore, recommends that you
do not send any action-oriented or time-sensitive information to us via
electronic mail, or any confidential or sensitive information including:
social security numbers, account numbers, or personal identification numbers.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|