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

ADSM-L

[Top] [All Lists]

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

2009-02-12 13:19:57

Subject:	[ADSM-L] SQL SELECT to show what's mounted and why
From:	Roger Deschner <rogerd AT UIC DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Thu, 12 Feb 2009 12:15:32 -0600

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

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] SQL SELECT to show what's mounted and why, Roger Deschner <= Re: [ADSM-L] SQL SELECT to show what's mounted and why, Huebschman, George J. Re: [ADSM-L] SQL SELECT to show what's mounted and why, Fred Johanson Re: [ADSM-L] SQL SELECT to show what's mounted and why, Colwell, William F. Re: [ADSM-L] SQL SELECT to show what's mounted and why, Richard Rhodes Re: [ADSM-L] SQL SELECT to show what's mounted and why, Roger Deschner

Previous by Date:	Re: [ADSM-L] TDPO RMAN problems, Clark, Robert A
Next by Date:	Re: [ADSM-L] SQL SELECT to show what's mounted and why, Huebschman, George J.
Previous by Thread:	Re: [ADSM-L] [OFFTOPIC] Announce online generator for LTO barcode labels, Seay, Lisa
Next by Thread:	Re: [ADSM-L] SQL SELECT to show what's mounted and why, Huebschman, George J.
Indexes:	[Date] [Thread] [Top] [All Lists]