RE: IFS File usage report

I don't think most folks would find you message an infringement of the rules
of the list as we tend to follow them.
Usually when we post something of a more commercial nature we simply start
it with "Vendor Response" and offer to take off line calls if the OP wishes
to call.

Conversely now attempting to contact the OP directly would be "mining the
list" which is prohibited.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Spencer Elliott
Sent: Friday, August 18, 2017 9:15 PM
To: Midrange Systems Technical Discussion
Subject: 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

--
Spencer C Elliott
S4i Systems Inc.
616 South El Camino Real, Suite M
San Clemente, CA 92672

Office: 949-366-5234 x152
Fax: 949-366-5338
Web: http://www.s4isystems.com
--
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