Re: AW: Extend and Reorg PF

DSPFD *ALL/*ALL (or library) *mbrlist *PF's outfile(lib/name)

Then a quickie DBU to see your fields and a simple qry to select the
fields you want, criteria (deleted records >0) and you have all you
need.

On 2026-04-01 10:39, myibmi via RPG400-L wrote:

> Hi,
> DSPFD is your friend.
> 
> -----Ursprüngliche Nachricht-----
> Von: RPG400-L [mailto:[email protected]] Im Auftrag von
> Jerry Forss
> Gesendet: Mittwoch, 1. April 2026 16:18
> An: [email protected]
> Betreff: Extend and Reorg PF
> 
> I have the need to check all PF if they are getting close to filling up,
> even with the extensions.
> 
> I can use to get number of current records and deleted records.
> 
> SELECT A.SYS_DNAME,A.SYS_TNAME,A.FILETYPE,A.TYPE,
> B.NUMBER_ROWS,B.DELETED,B.DATA_SIZE,B.LASTUSED
> FROM SYSTABLES A JOIN SYSTABLESTAT B
> ON A.SYS_DNAME = B.SYS_DNAME AND A.SYS_TNAME = B.SYS_TNAME
> WHERE A.SYS_DNAME = 'UTILITIES'
> 
> How do I get the file capacity so I know if the file is getting close to
> filling up?
> 
> I would do a CHGPF  to increase capacity.
> 
> Subject to Change Notice:
> 
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
> 
> Confidentiality Notice:
> 
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You
> 
> WalzCraft PO Box 1748 La Crosse, WI, 54602-1748
> www.walzcraft.com [1]<https://www.walzcraft.com> Phone: 1-800-237-1326
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
> 
> Please contact [email protected] for any subscription related
> questions.
 

Links:
------
[1] http://www.walzcraft.com
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.