Thanks David ...
tsm: TSM>select volume_name,node_name from volumeusage where node_name='MEDRS1'
and stgpool_name='COPYPOOL' group by volume_name,node_name
VOLUME_NAME NODE_NAME
------------------ ------------------
MED200 MEDRS1
MED202 MEDRS1
MED251 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1
tsm: TSM>select volume_name,node_name from volumeusage where node_name='MEDRS1'
and stgpool_name='TAPEPOOL' group by volume_name,node_name
VOLUME_NAME NODE_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: TSM>select volume_name,node_name from volumeusage where node_name
='MEDRS1'g
roup by volume_name,node_name where stgpool_name='TAPEPOOL'
VOLUME_NAME NODE_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: TSM>select volume_name,node_name from volumeusage where node_name='MEDRS1'g
roup by volume_name,node_name where stgpool_name='COPYPOOL'
VOLUME_NAME NODE_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: TSM>Q DRM
Volume Name State Last Update Automated
Date/Time LibName
---------------- ----------------- ------------------- ----------------
000064 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: TSM>Q VOL
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
(MB)
------------------------ ----------- ---------- --------- ----- --------
/tsmpool/data01.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data02.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data03.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data04.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data05.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data06.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
/tsmpool/data07.dsm DISKPOOL DISK 5,000.0 0.0 On-Line
000064 COPYPOOL STK9710 0.0 0.0 Pending
MED200 COPYPOOL STK9710 82,666.6 40.8 Full
MED201 TAPEPOOL STK9710 51,703.6 46.5 Full
MED204 TAPEPOOL STK9710 71,680.0 0.6 Filling
MED215 TAPEPOOL STK9710 71,680.0 9.6 Filling
MED219 TAPEPOOL STK9710 71,680.0 1.2 Filling
MED221 TAPEPOOL STK9710 71,680.0 1.7 Filling
MED225 TAPEPOOL STK9710 71,680.0 2.3 Filling
MED231 TAPEPOOL STK9710 71,680.0 3.0 Filling
MED233 TAPEPOOL STK9710 71,680.0 23.2 Filling
more... (<ENTER> to continue, 'C' to cancel)
MED235 TAPEPOOL STK9710 71,680.0 6.6 Filling
MED250 TAPEPOOL STK9710 71,680.0 5.6 Filling
MED251 COPYPOOL STK9710 55,945.3 64.9 Full
MED252 COPYPOOL STK9710 0.0 0.0 Pending
MED254 COPYPOOL STK9710 121,199.6 1.0 Full
MED255 TAPEPOOL STK9710 87,072.9 47.3 Full
MED260 COPYPOOL STK9710 44,541.5 77.6 Full
MED261 COPYPOOL STK9710 94,341.1 30.2 Full
MED262 TAPEPOOL STK9710 71,680.0 81.5 Filling
MED264 TAPEPOOL STK9710 71,680.0 17.3 Filling
MED268 TAPEPOOL STK9710 106,456.6 44.6 Full
MED271 COPYPOOL STK9710 0.0 0.0 Pending
MED304 TAPEPOOL STK9710 71,680.0 4.5 Filling
MED311 COPYPOOL STK9710 0.0 0.0 Pending
MED316 TAPEPOOL STK9710 71,680.0 5.1 Filling
MED317 TAPEPOOL STK9710 71,680.0 0.6 Filling
MED375 COPYPOOL STK9710 0.0 0.0 Pending
MED401 TAPEPOOL STK9710 0.0 0.0 Pending
MED403 TAPEPOOL STK9710 90,793.9 38.0 Full
MED404 TAPEPOOL STK9710 0.0 0.0 Pending
MED411 TAPEPOOL STK9710 0.0 0.0 Pending
MED414 COPYPOOL STK9710 0.0 0.0 Pending
more... (<ENTER> to continue, 'C' to cancel)
MED416 TAPEPOOL STK9710 71,680.0 2.7 Filling
MED501 COPYPOOL STK9710 81,604.0 100.0 Full
MED503 COPYPOOL STK9710 0.0 0.0 Pending
MED506 TAPEPOOL STK9710 71,680.0 61.1 Filling
MED507 COPYPOOL STK9710 71,680.0 12.6 Filling
MED511 COPYPOOL STK9710 71,680.0 49.4 Filling
MED513 COPYPOOL STK9710 71,680.0 61.3 Filling
MED514 COPYPOOL STK9710 71,680.0 7.3 Filling
MED560 TAPEPOOL STK9710 0.0 0.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: TSM>select volume_name,node_name from volumeusage where node_name='MEDRS1'g
roup by volume_name,node_name
VOLUME_NAME NODE_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: 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.
"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.
=======================================
"MMS <health-first.org>" made the following
annotations on 03/01/01 16:34:47
------------------------------------------------------------------------------
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.
=======================================
$RFC822.eml
