Re: SELECT statement to determine if any drives available

Actually, the field DRIVES table, ALLOCATED_TO has the information. Select drive_name, device_type from drives where allocated_to IS NULL This works on V4.2. This area dramatically changed on V5. I do not have a V5 system to look at what is required to get the same answer. Paul D. Seay, Jr. Te

Re: SELECT statement to determine if any drives available

Is there any way to set operational priority of the client.

Re: SELECT statement to determine if any drives available

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

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

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

> 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

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

| |cc: | | Subject: Re: SELECT statem

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

Re: SELECT statement to determine if any drives available

If you are just needing to know if reclamation is running, you might just look at the adsm.processes table... tsm: TSMSRV02>select * from processes PROCESS_NUM: 2193 PROCESS: Space Reclamation START_TIME: 2002-12-19 07:31:00.00 FILES_PROCESSED: 5831 BYTES_PROCESSED: 479807582