We use this for sessions. It ought to be easy to add processes. select client_name as "Client",session_id as "Session",substr(output_vol_access,3,6) as "Tape Volume" from sessions - where output_vol_access is not null and substr(output_vol_access,3,6) in (select volume_name from volumes where devclass_name='GEN2')
Fred Johanson TSM Administrator University of Chicago 773-702-8464 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Roger Deschner Sent: Thursday, February 12, 2009 12:16 PM To: ADSM-L@VM.MARIST.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 rog...@uic.edu Academic Computing & Communications Center ======I have not lost my mind -- it is backed up on tape somewhere.=====