Re: IFS File usage report

(accidentally replied privately)

I use the following from ACS RunSQL scripts after gathering the RTVDIRINFO to a library called DIRINFO,

SBMJOB CMD(RTVDIRINF DIR(/) INFLIB(DIRINFO)
OMIT('/qsys.lib' '/qdls')) JOB(RTVDIRINFO)


SELECT dirinfo.Qaezd0001o.Qezalcsize
,CAST(dirinfo.Qaezd0001o.Qezobjnam AS CHAR(30)) AS Objnam
,Dirinfo.Qaezd0001d.Qezdirnam1
FROM Dirinfo.Qaezd0001o INNER
JOIN Dirinfo.Qaezd0001d ON dirinfo.Qaezd0001o.Qezdiridx = dirinfo.Qaezd0001d.Qezdiridx
WHERE dirinfo.Qaezd0001o.Qezalcsize > 1000000
ORDER BY dirinfo.Qaezd0001o.Qezalcsize DESC ;

SELECT DISTINCT COUNT(Dirinfo.Qaezd0001o.Qezdiridx) AS Tot_In_Dir
,Dirinfo.Qaezd0001o.Qezdiridx
,Dirinfo.Qaezd0001d.Qezdirnam1
FROM Dirinfo.Qaezd0001o INNER
JOIN Dirinfo.Qaezd0001d ON Dirinfo.Qaezd0001o.Qezdiridx = Dirinfo.Qaezd0001d.Qezdiridx
GROUP BY Dirinfo.Qaezd0001o.Qezdiridx
,Dirinfo.Qaezd0001d.Qezdirnam1
ORDER BY Tot_In_Dir DESC ;


Bryan

*SQL culled from this list


Steve Pavlichek wrote on 8/18/2017 12:50 PM:

Is there an easy way to determine disk space usage from the IFS by directory and subdirectory? I recently migrated a customer and the IFS restore took forever. Found out that one directory of the IFS had over 7.9 million log files.

I used the RTVDIRINF and PRTDIRINF commands but the report was over 100k pages as it details every subdirectory. The files the RTVDIRINF created (QAEZD0001O and QAEZD0001D) did not have the directory names in readable form.

Looking for # of objects and total size by directory and sub-directory.