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.