Re: [ADSM-L] Total bytes per node ?
2007-03-20 00:35:12
Hi!
You can also use the native command "q occ * *" or "q occ node_name *" to
get that information.
Cheers!
Pablito.
Suad Musovich
<musovich AT NZ1 DOT IBM
.COM> To
Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
Dist Stor cc
Manager"
<[email protected] Subject
.EDU> Re: [ADSM-L] Total bytes per node ?
20/03/2007 15:46
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
something like:
select node_name,sum(physical_mb) as "Physical MB" from occupancy group by
node_name order by "Physical MB" desc
You could be more specific and mask on the stgpool name (that is, if you
have a consistent descriptive naming scheme for stgpools)
TABNAME COLNAME TYPENAME LENGTH
------------------ ------------------ ------------------
-----------
OCCUPANCY NODE_NAME VARCHAR 64
OCCUPANCY TYPE VARCHAR 20
OCCUPANCY FILESPACE_NAME VARCHAR 64
OCCUPANCY STGPOOL_NAME VARCHAR 30
OCCUPANCY NUM_FILES INTEGER 0
OCCUPANCY PHYSICAL_MB DECIMAL 14
OCCUPANCY LOGICAL_MB DECIMAL 14
OCCUPANCY FILESPACE_ID INTEGER 0
Cheers, Suad
--
> Greetings. (newbie warning :-) Is there a query which would reveal
> the total bytes of tape being consumed by a particular node ?
> i.e. including the active and inactive copies of all its objects ?
>
> Regards, Peter
>
> AUS/TAS/DPIW/CIT/Servers hbt/lnd/l8 6233 3061 http://www.pjb.com.au
> Pasari, pasarimos dice el agua y canta la verdad contra la piedra
> -- Pablo Neruda
|
|
|