q occu
  or
select * from occupancy

Steve Hicks schrieb:
> 
> 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 >>

-- 
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

Reply via email to