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
