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