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
tlaporte AT anim.dreamworks DOT com
On Thu, 1 Mar 2001, Shekhar Dhotre wrote:
>
>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 <David.Longo AT HEALTH-FIRST DOT ORG>@VM.MARIST.EDU> on 03/01/2001
>04:28:55
>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 ?
>
>
>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
>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 <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
>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
>----- Original Message -----
>From: Shekhar Dhotre <shekhar.dhotre.b AT BAYER DOT COM>
>To: <ADSM-L AT VM.MARIST DOT EDU>
>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.
>
>=======================================
>
>
|
