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