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