At 11:52 AM 12/19/02 -0500, you wrote:

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