ADSM-L

Re: Need help controlling explosive growth

1998-09-15 16:25:02
Subject: Re: Need help controlling explosive growth
From: Dave Larimer <david.larimer.hnj9 AT STATEFARM DOT COM>
Date: Tue, 15 Sep 1998 15:25:02 -0500
Try the GUI under filespaces.  You can sort by largest filespaces and find
the largest users that way or dump it to a file and sort it using sas or
excell.  Try that.




From: O1=INET00/C=US/A=IBMX400/P=STATEFARM/DD.RFC-822=ADSM-L\@VM.MARIST.EDU
on 09/15/98 12:20:09 PM
To:   ADSM-L
cc:
Subject:  Need help controlling explosive growth

During our daily DRM process, we backup the storage pool to tape.  In
the last two weeks, we've nearly doubled the number of tapes we
generate.  How can we find out who are the big users?  I see no total
usage stats maintained at the filespace level (too bad).  How do I write
QUERY/SELECT on all files (which number in the hundreds of thousands),
grouped by node, without it taking forever to compute?  Am I better off
dumping the query output to disk and then using something like SAS to
process?  Any ideas anyone?