Thanks for the suggestion

> -----Original Message-----
> From: Bernhard Unold [SMTP:Bernhard.Unold AT MED.UNI-TUEBINGEN DOT DE]
> Sent: Friday, March 02, 2001 1:21 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: How to find out what tape's a client data are on ?
> 
> 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:
> ADSM-L AT VM.MARIST DOT EDU
> >                     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: andrew.raibeck AT tivoli DOT com
> > "The only dumb question is the one that goes unasked."
> > 
> > Shekhar Dhotre <shekhar.dhotre.b AT BAYER DOT COM>@VM.MARIST.EDU> on 
> > 03/01/2001
> > 10:41:16 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 .Worked .. .. i was thinking that TSM is not case sensitive
> > application
> > .. hmm..
> > 
> > Glen Churchfield <gchurchf AT BWC.STATE.OH DOT US>@VM.MARIST.EDU> on 
> > 03/01/2001
> > 11:57:38 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 ?
> > 
> > Shekhar,
> > Remember that the node name is case sensitive and is all caps.
> > 
> > -----Original Message-----
> > From: Shekhar Dhotre [mailto:shekhar.dhotre.b AT BAYER DOT COM]
> > Sent: Thursday, March 01, 2001 11:40 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > 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)" <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
> > 
> > (See attached file: $RFC822.eml)
> > (See attached file: $RFC822.eml)
> > 
> >
> ------------------------------------------------------------------------
> >                   Name: $RFC822.eml
> >                   Name: $RFC822.eml
> >    $RFC822.eml    Type: application/x-unknown-content-type-eml_auto_file
> >               Encoding: base64
> 
> -- 
> Mit freundlichen Grüßen
> 
> 
> Bernhard Unold << File: Visitenkarte f|r Bernhard Unold >>