RGZPFM – AS400 (IBM i) - Reorganize Physical File Member | AS400 Tutorial for Beginners

Опубликовано: 23 Октябрь 2024
на канале: Bhavesh Nande
61
2

Lets understand what is RGZPFM and why it is required.

RGZPFM – Reorganize Physical File Member

1. What is RRN?
2. What happens when a PF record is deleted?
3. What happens when a record is inserted into a PF?
4. Why to RGZPFM?
a. Reclaiming Deleted Record Space
b. Improving Access Performance (defrag)
c. Consolidating Member Extents
d. Reclaiming Disk Space in Journaling or Replicated Environments
e. Rebuilding Logical File Access Paths
f. No Automatic Reuse of RRNs

#as400 #ibm #ibmi #rgzpfm #reorganize #database #sql #db2 #physicalfile