sum of numfiles must give total copies on the adsm server...
just tested... have a node whose "num_files" for /home is 13,256 but in that
filespace >ls -1 -R /home | wc -l   yields 4,196

Physical_MB will be what the node sent (compressed or uncompressed... what
came in over the network)

Logical_MB will be what is on your adsm/tsm server...

example... I had a node with compression "on" and its physical & logical MB
were basically the same...

I turned compression "OFF" and pushed a selective of /home/someuid/ and
migrated it to tape (where the 3590 data compression took over)
and here is what it shows now...

     NODE_NAME: TTCSTG02
          TYPE: Bkup
FILESPACE_NAME: /home
  STGPOOL_NAME: 3590P1
     NUM_FILES: 13410
   PHYSICAL_MB: 788.37
    LOGICAL_MB: 767.27

Dwight



> ----------
> From:         Andreas Rensch[SMTP:RenschA AT ALTE-LEIPZIGER DOT DE]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Thursday, July 06, 2000 10:01 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      SELECT and LOGICAL_MB and NUM_FILES
>
> Hi,
>
> when I submit a 'SELECT NODE_NAME, SUM(NUM_FILES)  AS ANZAHL_FILES,
> SUM(LOGICAL_MB) AS LOGICAL_MB FROM OCCUPANCY GROUP BY NODE_NAME' what do
> NUM_FILES and LOGICAL_MB stand for?
>
> Does NUM_FILES count the number of backup versions or different
> file(name)s?
> And is the LOGICAL_MB the amount of space in my storage pools or the
> amount
> of spae on my clients?
>
> mfg / regards
>
> andreas rensch / rz-qs
> tel : +49(0)6171 66 3692 / fax : +49(0)6171 66 7500 3692 /
> mailto:renscha AT alte-leipziger DOT de
> Alte Leipziger Lebensversicherung aG - Alte Leipziger Platz 1 - D 61440
> Oberursel - http://www.alte-leipziger.de
>
> Life's unfair. But SPECIAL and OPERATIONS help.
>