I can't help with Sql, but i wonder, why do you need tapes from offsite for a client restore? Perhaps this will not help you now, but my suggestion is, to backup your storage pool(s) and put the backups offsite. So for the next restore you will not have to recall a tape at all from offsite. Ask me, if you want to know more. Allen Barth schrieb: > > While your statement is technically true Andy, *SM does take the liberty > of folding various fields to UPPER CASE which IMHO is just plain dumb. > OOPS, forgot that mainframe heritage. > > Al Barth > Zurich Scudder Investments > > Andy Raibeck > <Andrew_Raibeck@T To: [EMAIL PROTECTED] > IVOLI.COM> cc: > Sent by: "ADSM: Subject: Re: How to find out what >tape's a client data are on ? > Dist Stor > Manager" > <[EMAIL PROTECTED] > .EDU> > > 03/01/01 11:47 AM > Please respond to > "ADSM: Dist Stor > Manager" > > 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) > (See attached file: $RFC822.eml) > > ------------------------------------------------------------------------ > Name: $RFC822.eml > $RFC822.eml Type: application/x-unknown-content-type-eml_auto_file > Encoding: base64 -- Mit freundlichen Grüßen Bernhard Unold
begin:vcard n:Unold;Bernhard tel;work:+49 7071/29-80130 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Bernhard Unold end:vcard
