Re: SHOW VOLUMEUSAGE <node>
2015-10-04 17:36:17
Where can i get a listing of the database catagories and the description of
what's in each one so that i can create my own queries?
Thanks,
Mooney
Siemens WestingHouse
(407) 249-7606
From: Joerg Pohlmann <jpohlman AT CA.IBM DOT COM> on 12/21/99 13:54
To: ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
cc:
Subject: Re: SHOW VOLUMEUSAGE <node>
There are many ways of getting volume information for a node based on
storage pool. For example, I use the following command to see on which
volumes in on-site storage pools a node resides (b.t.w. I defined a script
to do this so that parameter $1 is the node name):
select distinct volume_name from volumeusage where node_name= UPPER('$1')
and stgpool_name<>'COPYPOOL'
Regards,
Joerg Pohlmann
(604) 535-0452
Nathan King <nathan.king AT USAA DOT COM> on 99 12 21 10:35:19
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: SHOW VOLUMEUSAGE <node>
That's what the SQL Query was designed to do... I use it to generate a
report for chargeback.
If you want to see the volume numbers then just alter the query.
select distinct volume_name,node_name from volumeusage
should work
-----Original Message-----
From: Michael Dummitt [SMTP:Michael.Dummitt AT ROSSNUTRITION DOT COM]
Sent: Tuesday, December 21, 1999 12:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SHOW VOLUMEUSAGE <node>
Well I tried this command and I recvd the below output. I still do
not know
which volumes....it just tellsme how many. Any more hints? The
would
be
appreciated.
adsm> select node_name as aixs70a,count(distinct volume_name) as
"Number of tap
es used" from volumeusage group by node_name
ANR2963W This SQL query may produce a very large result table, or
may require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) y
AIXS70A Number of tapes used
------------------ --------------------
ADSMRS 58
AF_REMOTE 2
AIX01 94
AIX02 56
AIX03 95
AIX07 75
AIX08 51
AIX0A 41
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Re: SHOW VOLUMEUSAGE <node>, (continued)
- Re: SHOW VOLUMEUSAGE <node>, Frederic Landreville
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- Re: SHOW VOLUMEUSAGE <node>, Nathan King
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- Re: SHOW VOLUMEUSAGE <node>, Nathan King
- Re: SHOW VOLUMEUSAGE <node>, Joerg Pohlmann
- Re: SHOW VOLUMEUSAGE <node>, Mark Mooney
- Re: SHOW VOLUMEUSAGE <node>, Joshua S. Bassi
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- SHOW VOLUMEUSAGE <node>, Medico, Frederic
- Re: SHOW VOLUMEUSAGE <node>,
ADSM : Dist Stor Manager [mailto:ADSM-L <=
|
|
|