The only way I can think of figuring this out (and this is what I've done
in the past)
is to update the dsm.opt with the verbose option.  Then look at the
dsmsched.log.
The only sql tables which I can think of which reference files and bytes is
the
backups table and the summary table.  Unfortunately there is no correlation
between the filename (backups - ll_name) and the bytes transferred.
However,
this information is logged in the client schedule log when verbose is
specified in
the dsm.opt file.

If anybody else know of an alternate method I too would be very interested.

Regards,

Denis L. L'Huiller
973-360-7739
dlhuillier AT pershing DOT com
Enterprise Storage Forms ->
http://admpwb01/misc/misc/storage_forms_main.html



                    Zoltan
                    Forray/AC/VCU        To:     ADSM-L AT VM.MARIST DOT EDU
                    <zforray@VCU.        cc:
                    EDU>                 Subject:     Re: Handling spikes in 
storage transfer
                    Sent by:
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    01/14/2002
                    02:56 PM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"






Thanks, but, I am looking for file-level information.

I have the "bytes transfered per node" info from the SMF ACCOUNTING
records generated by the server. I can tell HOW MANY BYTES WERE TRANSFERED
for this node, back to the day it first started talking to TSM. I need to
know what files and how big.
----------------------------------------------------------------------------------------------------
Zoltan Forray
Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: zforray AT vcu DOT edu  -  voice: 804-828-4807




"Denis L'Huillier" <dlhuillier AT PERSHING DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/14/2002 02:33 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Handling spikes in storage transfer


Try,
select  sum(bytes) from summary where entity='SuspectedAbuser' and
activity
='BACKUP' and start_time between '2002-01-13 00:00' and '2002-01-14 00:00'

This will give you in bytes the amount of data  a particular node sent to
the server in a 24 hour period.
Adjust the start_time and entity as required.

You can also do a
select entity, sum(bytes) blah blah blah blah group by entity
This will give you the bytes for all nodes.

Hope this helps.

Regards,

Denis L. L'Huiller
973-360-7739
dlhuillier AT pershing DOT com
Enterprise Storage Forms ->
http://admpwb01/misc/misc/storage_forms_main.html



                    Zoltan
                    Forray/AC/VCU        To:     ADSM-L AT VM.MARIST DOT EDU
                    <zforray@VCU.        cc:
                    EDU>                 Subject:     Re: Handling spikes
in storage transfer
                    Sent by:
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    01/14/2002
                    11:02 AM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"






I already tried that. The information it gives isn't detailed enough. It
just tells me about the filespaces.

I need to know specifics, such as the names/sizes of the files/objects in
the file spaces.

Anybody have any sql to do such ?

Thanks, anyway !
----------------------------------------------------------------------------------------------------
Zoltan Forray
Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: zforray AT vcu DOT edu  -  voice: 804-828-4807




"Cook, Dwight E (SAIC)" <cookde AT BP DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/14/2002 10:29 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Handling spikes in storage transfer


Do a "q occ <nodename>" and look for what file systems are out on your
diskpool in great quantity.
That is, if you send all data first to a diskpool and then bleed it off to
tape (daily).
That will give you an idea of what file systems are sending the most data,
currently.
Then you may perform something like a "show version <nodename>
<filespacename> to see each specific item.
        you might note the "filecount" in the "q occ" listing to see how
much will be displayed in the "show version" command.

hope this helps...
        later,
                Dwight