ADSM-L

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

2009-02-12 13:54:54
Subject: Re: [ADSM-L] SQL SELECT to show what's mounted and why
From: "Colwell, William F." <bcolwell AT DRAPER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 12 Feb 2009 13:51:28 -0500
Roger,

I have a script called 'qdr' to show the drives and the tapes on each.
The script also
executes scripts in the library manager client servers to get details of
the usage.

The scripts and sample output are in the attached file.

Hope this helps,

Bill Colwell
Draper Lab



-----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: 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.=====

Attachment: qdr.txt
Description: qdr.txt