Re: Extend and Reorg PF

[Reeve <rfritchman@xxxxxxxxx>]

DSPFD to an *OUTFILE (column MBRCDC) gives you the record capacity.
Otherwise, the capacity is (initial_size + (records per increment * number
of increments)); I think that's SQL-able.

On Wed, Apr 1, 2026 at 7:18 AM Jerry Forss <JForss@xxxxxxxxxxxxx> wrote:

> 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<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: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.