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
david.longo AT health-first DOT org
>>> shekhar.dhotre.b AT BAYER DOT COM 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
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
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
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
/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 <David.Longo AT HEALTH-FIRST DOT ORG>@VM.MARIST.EDU> on 03/01/2001
01:06:56
PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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
david.longo AT health-first DOT org
>>> shekhar.dhotre.b AT BAYER DOT COM 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
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 <mpgimeno AT IBERCOM DOT ES>@VM.MARIST.EDU> on 02/28/2001
12:14:39 PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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
|