RE: IFS directories largest objects

RTVDIRINF now running for 40 minutes.
P7 with all SSD drives.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Roger Harman
Sent: Tuesday, November 18, 2014 2:00 PM
To: Midrange Systems Technical Discussion
Subject: 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.

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