Re: SELECT statement to determine if any drives available

2002-12-20 Thread Seay, Paul
. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Christian Sandfeld [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 7:34 AM To: [EMAIL PROTECTED] Subject: SELECT statement to determine if any drives available Hi list, Does anybody know of a SELECT

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Jacque Mergens
Is there any way to set operational priority of the client.

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David E Ehresman
I get server names in the allocated-to field with tsm server 5.1.1.6. David

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David E Ehresman
My allocated-to field contains either the storage agent name or the tsm server name when there is a tape mounted in the drive. David

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David Longo
en tapes are mounted to processes and restores..) -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: Re: SELECT statement to determine if any drives available select drive_name,drive_state,

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Gill, Geoffrey L.
> That's interesting - what shows up in your "allocated-to" > field? (Mine has nothing, even when tapes are mounted to > processes and restores..) Mine too. Probably just one of those "version" things again ;-) By the way, I opened a PMR on the problem of nodes reporting 0.00MB backed up and ot

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Prather, Wanda
ED] 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

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld
| |cc: | | Subject: Re: SELECT statem

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David E Ehresman
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

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Cook, Dwight E
put volume: AAE514. Dwight -Original Message- From: Christian Sandfeld [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 6:34 AM To: [EMAIL PROTECTED] Subject: SELECT statement to determine if any drives available Hi list, Does anybody know of a SELECT statement that w

SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld
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, Christia