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:[email protected]] On Behalf Of Roger Deschner Sent: Thursday, February 12, 2009 1:16 PM To: [email protected] 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 [email protected] 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.
