The file_size in the contents table is the aggregate size (if in use).  If
you look at each row in the table you will see something like the
following.  The 1/5, 2/5 in the AGGREGATED field indicates that 5 files
make up the aggregate, their total size is 3661 bytes.

   VOLUME_NAME: C:\TSMDATA\SERVER2\DISK1.DSM
     NODE_NAME: THINKPAD
          TYPE: Bkup
FILESPACE_NAME: \\ibm-cdhiv6vr881\c$
     FILE_NAME: \ DOCUMENTS AND SETTINGS
    AGGREGATED: 1/5
     FILE_SIZE: 3661
       SEGMENT:
        CACHED: No

   VOLUME_NAME: C:\TSMDATA\SERVER2\DISK1.DSM
     NODE_NAME: THINKPAD
          TYPE: Bkup
FILESPACE_NAME: \\ibm-cdhiv6vr881\c$
     FILE_NAME: \DOCUMENTS AND SETTINGS\ ADMINISTRATOR
    AGGREGATED: 2/5
     FILE_SIZE: 3661
       SEGMENT:
        CACHED: No

   VOLUME_NAME: C:\TSMDATA\SERVER2\DISK1.DSM
     NODE_NAME: THINKPAD
          TYPE: Bkup
FILESPACE_NAME: \\ibm-cdhiv6vr881\c$
     FILE_NAME: \DOCUMENTS AND SETTINGS\ADMINISTRATOR\ LOCAL SETTINGS
    AGGREGATED: 3/5
     FILE_SIZE: 3661
       SEGMENT:
        CACHED: No

   VOLUME_NAME: C:\TSMDATA\SERVER2\DISK1.DSM
     NODE_NAME: THINKPAD
          TYPE: Bkup
FILESPACE_NAME: \\ibm-cdhiv6vr881\c$
     FILE_NAME: \DOCUMENTS AND SETTINGS\ADMINISTRATOR\LOCAL SETTINGS\ TEMP
    AGGREGATED: 4/5
     FILE_SIZE: 3661
       SEGMENT:
        CACHED: No

   VOLUME_NAME: C:\TSMDATA\SERVER2\DISK1.DSM
     NODE_NAME: THINKPAD
          TYPE: Bkup
FILESPACE_NAME: \\ibm-cdhiv6vr881\c$
     FILE_NAME: \DOCUMENTS AND SETTINGS\ADMINISTRATOR\LOCAL SETTINGS\TEMP\
                 016041
    AGGREGATED: 5/5
     FILE_SIZE: 3661
       SEGMENT:
        CACHED: No

In my example the individual files in the aggregate are all smaller than
3661 bytes.  So if i ran a sum(file_size) I would see spurious results too.

You should be using something like q occu or q audito to see the amount of
client storage on your system.

Richard.


Ofer Nachom <ofer AT TRIP.CCC.CO DOT IL> on 20-06-2001 12:59:53

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  don't understand the select output




Hi There,

I am trying to get sum information about the client capacity on the TSM
Server.
I am executing the following command.
    " select sum(file_size) from contents where node_name like 'VOYAGER'
"
and getting that following result.

                                    Unnamed[1]
----------------------------------------------
                                292017475172
                                292017475172

The real capacity on  "VOYAGER"  is 27 GB.

It's seems to me that Voyager equipped 290GB  of space on my library.

so I checked a single file on the TSM server for VOYAGER with the
following command.

"select * from contents where node_name like 'VOYAGER'"

and compared it to the real file on the client.
the size of that  file is 3 time grater on the TSM server compared to
the file on the client.

why is the values from the tsm are grater from the client?. Is that
because of the number of the generation ?.
Is the client voyager rely equipped almost 300 GB on my library ?.

Thanks in advance.
Ofer Nachom
Triple C.