Re: IFS directories largest objects

That assumes you've run RtvDirInf with the *GEN option for output, correct?

Roger Harman

COMMON Certified Application Developer – ILE RPG on IBM i on Power

OCEAN User Group<http://www.ocean400.org> – Vice-President, Membership (2014)


----------------------------------------

Date: Tue, 18 Nov 2014 13:50:42 -0500
From: midrange@xxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: Re: IFS directories largest objects

SELECT qaezd0001o.qezalcsize, qaezd0001o.qezdtasize,
qaezd0001o.qezobjnam, qaezd0001d.qezdirnam1
FROM QAEZD0001O INNER JOIN QAEZD0001D on
qaezd0001O.qezdiridx= qaezd0001D.qezdiridx
WHERE qaezd0001o.qezalcsize> 1000000 <-select min size here
ORDER BY qaezd0001o.qezalcsize DESC <-and/or sequence here

Alternatively you can go into QP2TERM and use find to locate objects
over a certain size.

- Larry "DrFranken" Bolhuis

www.frankeni.com
www.iDevCloud.com
www.iInTheCloud.com

On 11/18/2014 1:47 PM, Roger Harman wrote:

There must be an API but one thought would be to run RTVDIRINF over the directory structure and then query that.

Roger Harman

COMMON Certified Application Developer – ILE RPG on IBM i on Power

OCEAN User Group – Vice-President, Membership (2014)

From: PSteinmetz@xxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: IFS directories largest objects
Date: Tue, 18 Nov 2014 18:30:29 +0000

Is there a command or tool that will sort IFS directories by size, so one can easily identify the largest objects?
4. Disk space tasks, 2. Print disk space information, will do libraries or folders, but not directories.
EDTF / 6=Path Size will give total directory size

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.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.

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