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

Reply via email to