What would the command be to show utilization of the tape vs. the client's
data. With collocation turned off, this command doesn't help too much by
itself. How would I query how much space is taken in my pool overall by one
client?
"Sharp, Neil
(London)" To: [EMAIL PROTECTED]
<SharpNei@EXCHANGE. cc:
UK.ML.COM> Subject: Re: How to find out what
tape's a client data are on ?
Sent by: "ADSM:
Dist Stor Manager"
<[EMAIL PROTECTED]
DU>
03/02/01 07:31 AM
Please respond to
"ADSM: Dist Stor
Manager"
Thanks for the suggestion
> -----Original Message-----
> From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 1:21 PM
> To: [EMAIL PROTECTED]
> 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:
> [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 << File: Visitenkarte f|r Bernhard Unold >>
