Cheers guys, I'll look into those posibilities :-)
/Christian
|---------+--------------------------->
| | David E Ehresman|
| | <deehre01@LOUISV|
| | ILLE.EDU> |
| | Sent by: "ADSM: |
| | Dist Stor |
| | Manager" |
| | <[EMAIL PROTECTED]|
| | T.EDU> |
| | |
| | |
| | 19-12-2002 15:38|
| | Please respond |
| | to "ADSM: Dist |
| | Stor Manager" |
| | |
|---------+--------------------------->
>-------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: SELECT statement to determine if any drives available
|
>-------------------------------------------------------------------------------------------------------------------------------|
select drive_name,drive_state,allocated_to,online from
drives
>>> [EMAIL PROTECTED] 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
