RE: [EXTERNAL] Re: Quick question on file behavior

Hi James

From the help on RGZPFM, 2nd paragraph

The Reorganize Physical File Member (RGZPFM) command removes deleted
records from (compresses) one member of a physical file in the
database, and it optionally reorganizes that member.

If a keyed file is identified in the Key file (KEYFILE) parameter,
the system reorganizes the member by changing the physical sequence
of the records in storage to either match the keyed sequence of the
physical file member's access path, or to match the access path of a
logical file member that is defined over the physical file.
Reorganization can decrease file processing time when a program is
reading sequentially through a keyed physical file or through a
keyed logical file.

When the member is reorganized and KEYFILE(*NONE) is not specified,
the sequence in which the records are actually stored is changed,
and any deleted records are removed from the file. If
KEYFILE(*NONE) is specified or defaulted, the sequence of the
records does not change, but deleted records are removed from the
etc.
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of James H. H. Lampert
Sent: Friday, July 10, 2020 5:19 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] Re: Quick question on file behavior

Jim Oberholtzer wrote:

Is reuse deleted records turned on, if so I highly doubt it.

Alan Shore wrote:

Has the file ever been re-orged (RGZPFM)?
How was it re-orged is then the question

Valid questions.

1. "Reuse" is set to *NO.

2. It hasn't seen a RGZPFM since the last 11,394 records (out of
1,446,092) were deleted, but that's no guarantee that it won't be at some future time.

3. "How it was re-orged"? There's more than one way to RGZPFM?

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

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com