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