Reorganizing a physical file member

You can reorganize a physical file member to change the manner in which records are stored on the IBM i operating system.

Reorganizing a physical file member using the Reorganize Physical File Member (RGZPFM) command
Reorganizing a table restores the table to its ideal physical organization. That is, the rows of the table are laid out on pages and ordered by their key values in some frequently used indexes. You can reorganize a table by compressing out deleted records by key. You can specify several key options when you reorganize a physical file member using the Reorganize Physical File Member (RGZPFM) command.
Usage notes: Reorganizing a physical file member
Here is a list of considerations for reorganizing a physical file member.
Reorganization options
You can specify whether the reorganize operation on a physical file member can or can not be canceled. Consider the features of each option when deciding which option to use.
Suspending or canceling a reorganize operation
Sometimes you might need to suspend or cancel a reorganize operation on a physical file member.

Parent topic: Physical file member operations