ADSM-L

Re: [ADSM-L] SQL SELECT to show what's mounted and why

2009-02-12 13:30:10
Subject: Re: [ADSM-L] SQL SELECT to show what's mounted and why
From: Fred Johanson <Fred AT UCHICAGO DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 12 Feb 2009 12:28:33 -0600
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Roger Deschner
Sent: Thursday, February 12, 2009 12: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.=====