Use upper-case within the single quotes for the node_name.
[EMAIL PROTECTED] on 01-Mar-2001 11:39
Please respond to [EMAIL PROTECTED]
To: ADSM-L
cc: (bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
Subject: Re: How to find out what tape's a client data are on ?
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)" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
03/01/2001 11:02:07 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 12:47 PM
> To: [EMAIL PROTECTED]
> 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
> [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]]
> Sent: jeudi 1 mars 2001 13:44
> To: [EMAIL PROTECTED]
> 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 : [EMAIL PROTECTED]
$RFC822.eml
