This is case sensitive. Your node name is probably MEDRS2. Node names (and
some other fields) are translated to ALL UPPER CASE when stored regardless of
case when entered.
Query commands don't care about case, select statements do.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5525
david.longo AT health-first DOT org
>>> shekhar.dhotre.b AT BAYER DOT COM 03/01/01 11:39AM >>>
I am trying same command for the One of my AIX Box , that is getting backed up
regularly .
I am not getting any output .. IS anything wrong here ..
tsm: TSM>select volume_name,node_name from volumeusage where node_name='medrs2'
group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
"Sharp, Neil (London)" <SharpNei AT EXCHANGE.UK.ML DOT COM>@VM.MARIST.EDU> on
03/01/2001 11:02:07 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: How to find out what tape's a client data are on ?
Thanks for your help. It has answered my question.
Neil
> -----Original Message-----
> From: Ruddy STOUDER [SMTP:Ruddy.Stouder AT IRISLINK DOT COM]
> Sent: Thursday, March 01, 2001 12:47 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: How to find out what tape's a client data are on ?
>
> Here is the SQL script :
>
> select volume_name,node_name from volumeusage where node_name='$1' group
> by volume_name,node_name
>
> Just give the server name as parameter 1
>
> Ruddy Stouder
> System Engineer
> I.R.I.S.
> Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
> B- 1435 Mont-Saint-Guibert
> ruddy.stouder AT irislink DOT com
> http://www.irislink.com
> Tel: +32 (0)10 48 75 10 - Fax: +32 (0)10 48 75 40
>
>
> -----Original Message-----
> From: Sharp, Neil (London) [mailto:SharpNei AT EXCHANGE.UK.ML DOT COM]
> Sent: jeudi 1 mars 2001 13:44
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How to find out what tape's a client data are on ?
>
>
> I have a frustrating situation whereby if I perform a client restore it
> may
> call a tape from off-site. This tape is then recalled (usually 4 hours)
> and
> then placed in the library. The restore then continues but then stalls
> again
> requesting another tape. What I need to find out up front are all the
> tapes
> that could possibly be requested for the client and recall all tapes. I
> can
> find this out by running 'q vol client=X' but I have 2000 tapes to
> search
> and this will take a long time even if scripted . I think that what I
> need
> is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
> shortly)
>
> Thanks for your time.
>
> Neil Sharp
> Merrill Lynch ADSM/TSM Administrator
> Work : 020-7573-0469
> Mobile : 07769-741612
> Pager : 01893-038277
> e-mail : neil_sharp AT ml DOT com
"MMS <health-first.org>" made the following
annotations on 03/01/01 11:56:12
------------------------------------------------------------------------------
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.
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.
===========================================================================
|
