Re: How to find out what tape's a client data are on ?

2001-03-05 Thread Bernhard Unold 

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@TTo:
  [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: TSMselect 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 volum

Re: How to find out what tape's a client data are on ?

2001-03-04 Thread Walker, Lesley R 

Andy Raibeck:
 Either way, I'm pretty sure that DISTINCT is supposed to
 account for distinct rows in their entirety, and not just certain columns.
 I'll have to look into this.

That's what I thought too.  My guess would be something to do with the SQL
interface not being direct to the database - something going missing in the
translation.

Anyway, it's good to know I'm not going mad.  :-)

In case you need to know, the system that produces these results is 3.7.4 on
Solaris, recently upgraded from an earlier 3.7 release.

Re: How to find out what tape's a client data are on ?

2001-03-02 Thread Bernhard Unold 

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@TTo: [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: TSMselect 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 :

Re: How to find out what tape's a client data are on ?

2001-03-02 Thread Sharp, Neil (London) 

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@TTo:
 [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: TSMselect 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
   ca

Re: How to find out what tape's a client data are on ?

2001-03-02 Thread Steve Hicks 

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@TTo:
 [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

Re: How to find out what tape's a client data are on ?

2001-03-02 Thread Andy Raibeck 

H that doesn't look right to me, either. Just from observation, it
looks as if the DISTINCT keyword is operating on either the first column in
the result set, or maybe the sorting key, since you are now sorting by
storage pool name. Either way, I'm pretty sure that DISTINCT is supposed to
account for distinct rows in their entirety, and not just certain columns.
I'll have to look into this.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."


"Walker, Lesley R" [EMAIL PROTECTED]@VM.MARIST.EDU on 03/02/2001
11:16:27 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 ?



 Just out of curiosity, since I've only casually been following
 this thread, was there a specific reason for the "group by"
 clause?

 I think what is desired is simplly an "order by" clause, e.g.

Well, I'm really confused now.

I came up with my own version of the query:

select distinct volume_name,stgpool_name
from volumeusage
where node_name='FOO'

and that produces an answer:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF013 CPITFPOOL
ITF018 CPITFPOOL
ITF026 CPITFPOOL
ITF001 ITFPOOL
ITF003 ITFPOOL
ITF004 ITFPOOL
ITF014 ITFPOOL
ITF025 ITFPOOL
ITF027 ITFPOOL
ITF028 CPITFPOOL
ITF006 ITFPOOL
ITF002 CPITFPOOL

BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF001 ITFPOOL

So what's going on here?

Re: How to find out what tape's a client data are on ?

2001-03-02 Thread Prather, Wanda 

I use this:
select stgpool_name, sum(physical_mb)  from occupancy where
node_name='XX' group by stgpool_name

-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 8:58 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?


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@TTo:
 [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: TSMselect 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:

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Thierry ITTY 

you can try :

dsmadmc -id=YOURNAME -pass=YOURPASS -outfile \
"select distinct(volume_name) \
from volumeusage \
where node_name='YOURNODE'"

hth


A 12:43 01/03/2001 -, vous avez crit :
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]


- * - * - * - * - * - * -
Mes idees n'engagent que moi (vieux proverbe du Net)

Thierry ITTY
eMail : [EMAIL PROTECTED]   FRANCE

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Ruddy STOUDER 

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]

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Sharp, Neil (London) 

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]

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Shekhar Dhotre 


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: TSMselect 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]


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread MORGAN TONY 

Try the nodename in UPPERCASE... It cut/pasted fine on my box. (4.1.1.2)

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 16:40
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: TSMselect 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]

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread David Longo 

This is case sensitive.  Your node name is probably MEDRS2.  Node names (and some 
other fields) are translated to ALL UPPER CASE when stored regardless of case when 
entered.

Query commands don't care about case, select statements do.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 11:39AM 

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: TSMselect 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] 



"MMS health-first.org" made the following
 annotations on 03/01/01 11:56:12
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

Ý==

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Kent J. Monthei 



Use upper-case within the single quotes for the node_name.





[EMAIL PROTECTED] on 01-Mar-2001 11:39



Please respond to [EMAIL PROTECTED]

To:   ADSM-L
cc:(bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
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: TSMselect 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]



 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Glen Churchfield 

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: TSMselect 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]

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Maria Paz Gimeno 

The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
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: TSMselect 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.

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Shekhar Dhotre 


tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query ?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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 ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
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: TSMselect 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.


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Shekhar Dhotre 


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: TSMselect 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]


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Andy Raibeck 

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: TSMselect 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)

 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Allen Barth 


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@TTo: [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: TSMselect 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)


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread David Longo 

Yes, all tapes are in this query.  To further define list add in the "where" clause 
the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query ?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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 ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
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: TSMselect 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.



"MMS health-first.org" made the following
 annotations on 03/01/01 13:12:48
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

Ý==

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Shekhar Dhotre 
  87,072.9   47.3Full
MED260COPYPOOL STK9710  44,541.5   77.6Full
MED261COPYPOOL STK9710  94,341.1   30.2Full
MED262TAPEPOOL STK9710  71,680.0   81.5  Filling
MED264TAPEPOOL STK9710  71,680.0   17.3  Filling
MED268TAPEPOOL STK9710 106,456.6   44.6Full
MED271COPYPOOL STK9710   0.00.0  Pending
MED304TAPEPOOL STK9710  71,680.04.5  Filling
MED311COPYPOOL STK9710   0.00.0  Pending
MED316TAPEPOOL STK9710  71,680.05.1  Filling
MED317TAPEPOOL STK9710  71,680.00.6  Filling
MED375COPYPOOL STK9710   0.00.0  Pending
MED401TAPEPOOL STK9710   0.00.0  Pending
MED403TAPEPOOL STK9710  90,793.9   38.0Full
MED404TAPEPOOL STK9710   0.00.0  Pending
MED411TAPEPOOL STK9710   0.00.0  Pending
MED414COPYPOOL STK9710   0.00.0  Pending
more...   (ENTER to continue, 'C' to cancel)

MED416TAPEPOOL STK9710  71,680.02.7  Filling
MED501COPYPOOL STK9710  81,604.0  100.0Full
MED503COPYPOOL STK9710   0.00.0  Pending
MED506TAPEPOOL STK9710  71,680.0   61.1  Filling
MED507COPYPOOL STK9710  71,680.0   12.6  Filling
MED511COPYPOOL STK9710  71,680.0   49.4  Filling
MED513COPYPOOL STK9710  71,680.0   61.3  Filling
MED514COPYPOOL STK9710  71,680.07.3  Filling
MED560TAPEPOOL STK9710   0.00.0  Pending





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 01:06:56
PM

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 ?


Yes, all tapes are in this query.  To further define list add in the "where"
clause the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query
?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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 ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
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: TSMselect 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.



"MMS health-first.org" made the following
 annotations on 03/01/01 13:12:48
--
This message is for the named person's use only.  It may contain confidential,
proprietary, or legally privileged information.  No confidentiality or privilege
is waived or lost by any mistransmission.  If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it, and notify the sender.  You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread David Longo 
 STK9710  71,680.06.6  Filling
MED250TAPEPOOL STK9710  71,680.05.6  Filling
MED251COPYPOOL STK9710  55,945.3   64.9Full
MED252COPYPOOL STK9710   0.00.0  Pending
MED254COPYPOOL STK9710 121,199.61.0Full
MED255TAPEPOOL STK9710  87,072.9   47.3Full
MED260COPYPOOL STK9710  44,541.5   77.6Full
MED261COPYPOOL STK9710  94,341.1   30.2Full
MED262TAPEPOOL STK9710  71,680.0   81.5  Filling
MED264TAPEPOOL STK9710  71,680.0   17.3  Filling
MED268TAPEPOOL STK9710 106,456.6   44.6Full
MED271COPYPOOL STK9710   0.00.0  Pending
MED304TAPEPOOL STK9710  71,680.04.5  Filling
MED311COPYPOOL STK9710   0.00.0  Pending
MED316TAPEPOOL STK9710  71,680.05.1  Filling
MED317TAPEPOOL STK9710  71,680.00.6  Filling
MED375COPYPOOL STK9710   0.00.0  Pending
MED401TAPEPOOL STK9710   0.00.0  Pending
MED403TAPEPOOL STK9710  90,793.9   38.0Full
MED404TAPEPOOL STK9710   0.00.0  Pending
MED411TAPEPOOL STK9710   0.00.0  Pending
MED414COPYPOOL STK9710   0.00.0  Pending
more...   (ENTER to continue, 'C' to cancel)

MED416TAPEPOOL STK9710  71,680.02.7  Filling
MED501COPYPOOL STK9710  81,604.0  100.0Full
MED503COPYPOOL STK9710   0.00.0  Pending
MED506TAPEPOOL STK9710  71,680.0   61.1  Filling
MED507COPYPOOL STK9710  71,680.0   12.6  Filling
MED511COPYPOOL STK9710  71,680.0   49.4  Filling
MED513COPYPOOL STK9710  71,680.0   61.3  Filling
MED514COPYPOOL STK9710  71,680.07.3  Filling
MED560TAPEPOOL STK9710   0.00.0  Pending





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 01:06:56
PM

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 ?


Yes, all tapes are in this query.  To further define list add in the "where"
clause the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED] 


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query
?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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 ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
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: TSMselect 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.



"MMS health-first.org" made the following
 annotations on 03/01/01 13:12:48
--
This message is for the named person's use only.  It may contain confidential,
proprie

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Shekhar Dhotre 


Thanks David ...

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='COPYPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED202 MEDRS1
MED251 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='TAPEPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED201 MEDRS1
MED255 MEDRS1
MED506 MEDRS1





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 04:28:55
PM

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 ?


Your select statement is incorrect.  It should be:

select volume_name,node_name from volumeusage where node_name='MEDRS1' and
stgpool_name='COPYTAPE' group by volume_name,node_name


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 02:48PM 

 The following query shows  same tapes  for  node 'MEDRS1' in tapepool and
copypool ?

  tsm: TSMselect volume_name,node_name from volumeusage where node_name
='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='TAPEPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='COPYPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMQ DRM

Volume NameState   Last Update   Automated
   Date/Time LibName
   -   ---   
64 Vault   02/22/01   12:08:00
MED200 Vault   02/16/01   15:38:21
MED251 Vault   02/16/01   15:38:22
MED252 Vault   02/23/01   13:38:02
MED254 Vault   02/26/01   10:43:13
MED260 Vault   02/19/01   10:36:43
MED261 Vault   02/19/01   10:36:43
MED271 Vault   02/26/01   10:43:13
MED311 Vault   02/19/01   10:36:43
MED375 Vault   02/27/01   10:48:18
MED414 Vault   02/20/01   11:42:36
MED501 Vault   03/01/01   12:47:40
MED503 Vault   02/21/01   10:47:50
MED511 Vault   02/27/01   10:48:18
MED513 Vault   03/01/01   12:47:40
MED514 Vault   03/01/01   12:47:40
MED515 Vault   03/01/01   12:49:00
MED512 Vault   03/01/01   12:49:00
more...   (ENTER to continue, 'C' to cancel)

MED413 Vault   02/27/01   10:49:43
MED510 Vault   02/26/01   10:44:30
MED374 Vault   02/26/01   10:44:30
MED269 Vault   02/26/01   10:44:30
MED253 Vault   02/23/01   13:39:13


tsm: TSMQ VOL

Volume Name   Storage  Device  EstimatedPct   Volume
  Pool NameClass Name   Capacity   Util   Status
(MB)
  ---  --  -  -  
/tsmpool/data01.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data02.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data03.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data0

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Thomas A. La Porte 

Just out of curiosity, since I've only casually been following
this thread, was there a specific reason for the "group by"
clause?

I think what is desired is simplly an "order by" clause, e.g.

select volume_name, node_name -
  from volumeusage -
 where node_name = 'MEDRS1' -
   and stgpool_name = 'COPYPOOL' -
 order by volume_name, node_name

The group by function is necessary when there is a group function
in the "select" statement, e.g. when you are summing a value:

select node_name, sum(backup_copy_mb) -
  from auditocc -
 where node_name = 'MEDRS1' -
 group by node_name


 -- Tom

Thomas A. La Porte
DreamWorks SKG
[EMAIL PROTECTED]

On Thu, 1 Mar 2001, Shekhar Dhotre wrote:


Thanks David ...

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='COPYPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED202 MEDRS1
MED251 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='TAPEPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED201 MEDRS1
MED255 MEDRS1
MED506 MEDRS1





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 04:28:55
PM

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 ?


Your select statement is incorrect.  It should be:

select volume_name,node_name from volumeusage where node_name='MEDRS1' and
stgpool_name='COPYTAPE' group by volume_name,node_name


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 02:48PM 

 The following query shows  same tapes  for  node 'MEDRS1' in tapepool and
copypool ?

  tsm: TSMselect volume_name,node_name from volumeusage where node_name
='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='TAPEPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='COPYPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMQ DRM

Volume NameState   Last Update   Automated
   Date/Time LibName
   -   ---   
64 Vault   02/22/01   12:08:00
MED200 Vault   02/16/01   15:38:21
MED251 Vault   02/16/01   15:38:22
MED252 Vault   02/23/01   13:38:02
MED254 Vault   02/26/01   10:43:13
MED260 Vault   02/19/01   10:36:43
MED261 Vault   02/19/01   10:36:43
MED271 Vault   02/26/01   10:43:13
MED311 Vault   02/19/01   10:36:43
MED375 Vault   02/27/01   10:48:18
MED414 Vault   02/20/01   11:42:36
MED501 Vault   03/01/01   12:47:40
MED503 Vault   02/21/01   10:47:50
MED511 Vault   02/27/01   10:48:18
MED513 Vault   03/01/01   12:47:40
MED514 Vault   03/01/01   12:47:40
MED515 Vault   03/01/01   12:49:00
MED512 Vault   03/01/01   12:49:00
more...   (ENTER to continue, 'C' to cancel)

MED413 Vault   02/27/01   10:49:43
MED510 Vault   02/26/01   10:44:30
MED374

Re: How to find out what tape's a client data are on ?

2001-03-01 Thread Walker, Lesley R 

 Just out of curiosity, since I've only casually been following
 this thread, was there a specific reason for the "group by"
 clause?

 I think what is desired is simplly an "order by" clause, e.g.

Well, I'm really confused now.

I came up with my own version of the query:

select distinct volume_name,stgpool_name
from volumeusage
where node_name='FOO'

and that produces an answer:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF013 CPITFPOOL
ITF018 CPITFPOOL
ITF026 CPITFPOOL
ITF001 ITFPOOL
ITF003 ITFPOOL
ITF004 ITFPOOL
ITF014 ITFPOOL
ITF025 ITFPOOL
ITF027 ITFPOOL
ITF028 CPITFPOOL
ITF006 ITFPOOL
ITF002 CPITFPOOL

BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF001 ITFPOOL

So what's going on here?