Re: SELECT statement to determine if any drives available
2002-12-19 11:53:41
That's interesting - what shows up in your "allocated-to" field? (Mine has
nothing, even when tapes are mounted to processes and restores..)
-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU]
Sent: Thursday, December 19, 2002 9:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SELECT statement to determine if any drives available
select drive_name,drive_state,allocated_to,online from
drives
>>> csa AT FERROSAN DOT COM 12/19/02 07:34AM >>>
Hi list,
Does anybody know of a SELECT statement that will show if any drives
are
available for use (not in use by another process or session)?
I need this for scripting purposes as I have only two drives in my
library,
and while doing reclamation both drives are in use.
Kind regards,
Christian
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SELECT statement to determine if any drives available, Christian Sandfeld
- Re: SELECT statement to determine if any drives available, Cook, Dwight E
- Re: SELECT statement to determine if any drives available, David E Ehresman
- Re: SELECT statement to determine if any drives available, Christian Sandfeld
- Re: SELECT statement to determine if any drives available,
Prather, Wanda <=
- Re: SELECT statement to determine if any drives available, Gill, Geoffrey L.
- Re: SELECT statement to determine if any drives available, David Longo
- Re: SELECT statement to determine if any drives available, David E Ehresman
- Re: SELECT statement to determine if any drives available, David E Ehresman
- Re: SELECT statement to determine if any drives available, Jacque Mergens
- Re: SELECT statement to determine if any drives available, Seay, Paul
|
|
|