Re: IFS File usage report

Hi,
I am not sure if it is proper to put in a product plug, but S4i DSDS-Plus
will survey files in the IFS down to the sub-directory level by file type,
dates, size and other criteria. I addition it will run a series of commands
against the files in the list (e.g.: delete, copy, ect) to automatically
cleanup the IFS.

I apologize if I have offended anyone or violated the use of this group,

Spencer

On Fri, Aug 18, 2017 at 2:08 PM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

(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.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD