RGZPFM - Reorganize Physical File Member
- 0.5
- 1
- 1.25
- 1.5
- 1.75
- 2
DESCRIPTION
Db2 is at the core of the IBM i, and making sure that databases are optimized is an important admin task. Holly Rademacher has been helping IBM i clients solve database issues for over 25 years, and in this episode she takes us on a deep dive into the Reorganize Physical File Member (RGZPFM) command. Holly talks about why it's important, how it works, when to run it, and what command options to look out for to make sure it runs correctly for you.
Use the following links to learn more about RGZPGM:
Memo To Users (Document 2023 changes to RGZPFM) https://www.ibm.com/docs/en/ssw_ibm_i_74/pdf/rzaq9.pdf
RGZPFM - Basics on Reorganize While Active https://www.ibm.com/support/pages/node/684543
RGZPFM options and comparison https://www.ibm.com/support/pages/node/668043
Viewing Status of RGZPFM through IBM i Access Client Solutions https://www.ibm.com/support/pages/node/684643
Today's Host

Kurt Schroeder
