Hi Thomas,
I got the following error when I ran that command:
ANR1464E RUN: Command script VOLUMESPERNODE, line 5, parameter 1 was not
specified: select volumes.volume_name as "Volume",volumes.stgpool_name as
"StgPool",volumes.est_capacity_mb as "Cap.(MB)",volumes.pct_utilized as
"Utlzd(%)",volumes.status as "Status",volumeusage.filespace_name as
"Filespace" from volumes,volumeusage where
volumes.volume_name=volumeusage.volume_name and
volumeusage.node_name=upper('$1').
ANR1463E RUN: Command script VOLUMESPERNODE completed in error.
Any ideas? Thanks!
********************************
Joni Moyer
Highmark
Storage Systems, Systems Programmer
NEW NUMBER: (717)302-9966
NEW FAX: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
"Thomas Rupp"
<Thomas.Rupp@ILLW
ERKE.AT> To
Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
Dist Stor cc
Manager"
<[email protected] Subject
.EDU> AW: [ADSM-L] Find # of tapes used
per node
11/18/2005 03:23
PM
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
I use the following script I got from this list (probably):
/* -------------------------------------------*/
/* Script Name: vols-node */
/* Description: List volumes per node */
/* Parameter: nodename */
/* Author: ilja.coolen AT abp DOT nl */
/* Example: run vols-node myUnixBox */
/* !!! WARNING !!! RESOURCE INTENSIVE !!! */
/* -------------------------------------------*/
select volumes.volume_name as "Volume",-
volumes.stgpool_name as "StgPool",-
volumes.est_capacity_mb as "Cap.(MB)",-
volumes.pct_utilized as "Utlzd(%)",-
volumes.status as "Status",-
volumeusage.filespace_name as "Filespace" -
from volumes,volumeusage -
where volumes.volume_name=volumeusage.volume_name and -
volumeusage.node_name=upper('$1')
HTH
Thomas Rupp
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag von
Joni Moyer
Gesendet: Freitag, 18. November 2005 21:19
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: [ADSM-L] Find # of tapes used per node
Hello,
I am trying to find out the number of onsite & offsite tapes that a
particular group of nodes are using. I have been using the following
select statement:
select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'COPY%' and node_name like 'FJSU%' group by node_name
select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'TAPE%' and node_name like 'FJSU%' group by node_name
but the results I get are adding up to more than the total number of tapes
that are being used by the environment, so I believe that I am getting
incorrect data. Could someone please let me know what I might be doing
wrong? Thanks!
********************************
Joni Moyer
Highmark
Storage Systems, Systems Programmer
Work:(717)302-6603
(717)302-9966 (NEW NUMBER as of 11/17/2005)
(717) 302-9826 (NEW FAX after 11/17/2006)
joni.moyer AT highmark DOT com
********************************
|