You, Me, and IBM i

RGZPFM - Reorganize Physical File Member


Listen Later

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

...more
View all episodesView all episodes
Download on the App Store

You, Me, and IBM iBy IBM