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. 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 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
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
Mine is blank also. I suspect that is used for if a drive is DEDICATED to a certain process, session or whatever. David Longo >>> [EMAIL PROTECTED] 12/19/02 11:52AM >>> 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:[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,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 "MMS " made the following annotations on 12/19/2002 01:18:02 PM -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
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 others not even being reported at all. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
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..) -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,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
Re: SELECT statement to determine if any drives available
Cheers guys, I'll look into those posibilities :-) /Christian |-+---> | | David E Ehresman| | | | | | 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
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
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: 4798075822 STATUS: Volume AAD615 (storage pool 3590P1), Moved Files: 6098, Moved Bytes: 4,798,478,585, Unreadable Files: 0, Unreadable Bytes: 0. Current Physical File (bytes): None Current input volume: AAD615. Current output 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 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
SELECT statement to determine if any drives available
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