Re: Sorting records in Physical and Logical files - RGZPFM with *RPLDLTRCD

The *RPLDLTRCD keyword designates a method available to recover space from deleted records [RRNs that remain in the dataspace of a member of a database physical file] without taking the file fully offline [as was required with the older RGZPFM invocations]. The new feature of the reorganize request, in the earliest manifestation, a file that is in use need not be released for much more than a few or less seconds. IIRC for the IBM i OS 6.1 the data segments that contain only deleted records can be truncated even when the file is in use. As such deleted records are not actually removed until the dataspace is truncated to remove those deleted rows that were since [effectively] moved to the end, from having used the request to RGZPFM KEYFILE(*RPLDLTRCD). Until the actual truncate activity, the reorganize request just relocates the deleted rows [within the dataspace].

Regards, Chuck

Jim Franz wrote:

Booth Martin wrote:

There is a REORGANIZE command that can be run to put records in
key sequence. Otherwise, it is arrival sequence.

The reorg cmd is RGZPFM.
It always removes deleted records.
Option to reorder records by the PF key (*FILE) or
by the key of a logical.
The *RPLDLTRCD actually says it will move recs from end of
file to replace deleted records (why?).