Re: IFS File usage report -- MIDRANGE-L

Hi Jim,
Vendor response! 😀 Thank you for the feedback. We will diffidently not
contact any members based on post here.
I too get aggravated when I get a sales call when I am busy but I also
remember what one of those guys told me "If no one sells no one eats!".

The list of vendors in the i space seems to be getting smaller and if there
are no applications then there is no need for the platform. Our company is
dictated to keeping the i the best platform for running commercial
applications. In fact, we just released a new open source (free) project
(Better Object Builder - BOB) for the i. IBM i programmers can now use Git
to manage ALL their i source and build it out of the IFS without creating
any CL. It uses GNU makefiles just like AIX, Linux and Unix.

Thank you,

Spencer

On Sat, Aug 19, 2017 at 2:56 PM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

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

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