Re: [ADSM-L] SQL SELECT to show what's mounted and why
2009-02-12 13:30:10
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.=====
|
|
|