IFS space usage, QRYIFSLIB

["Urbanek, Marty" <Marty_Urbanek@xxxxxxxxxxxx>]

Our V4R5 machine is too full and the disk space report shows about 11% "user
directories." I am trying to figure out what is taking the space.

I found a previous thread that sent me to testcase.boulder.ibm.com for some
IFStools. The tool named QRYIFSLIB might be helpful, but I can't get it to
work. I run the tool. It dumps the output to qgpl/qryifslib. Then I do a
STRSQL and enter the query they show in the program help text:

select DIRNAME, count(*) as "Number of Objects",
sum( cast(st_size as DEC(31) )) as "File Size",
sum( cast(st_allocsz as DEC(31) )) as "Allocated Size"
from qgpl/qryifslib group by DIRNAME

I get an error SQL0136 about the DIRNAME column being too long for a GROUP
BY. The column is 1998 in length. I know very little about SQL.

The stdout output that comes out of QRYIFSLIB also shows a total size.
However, I am running this thing on every user directory I can find and all
I have come up with is about 300MB but I am looking for 3GB. Is it possible
that when the disk space report says "user directories" it is also including
"Q" directories in the total?

Any ideas appreciated. Perhaps someone has a better way of finding out what
IFS directory is a space hog.

Thanks,
-Marty