This is not a case (no pun intended) of TSM being case-sensitive. Rather,
it is the standard SQL "is equal to" operator, '=', that is case sensitive
when comparing strings. This is per the SQL standard, and is not specific
to TSM's SQL implementation.
Regards,
Andy
Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
Shekhar Dhotre <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 03/01/2001
10:41:16 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 .Worked .. .. i was thinking that TSM is not case sensitive
application
.. hmm..
Glen Churchfield <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 03/01/2001
11:57:38 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 ?
Shekhar,
Remember that the node name is case sensitive and is all caps.
-----Original Message-----
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
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]
(See attached file: $RFC822.eml)
$RFC822.eml
