RGZPFM - Reorganize Physical File Member

Media Thumbnail
00:00
00:00
1x
  • 0.5
  • 1
  • 1.25
  • 1.5
  • 1.75
  • 2
This is a podcast episode titled, RGZPFM - Reorganize Physical File Member. The summary for this episode is: <p>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.</p><p><br></p><p>Use the following links to learn more about RGZPGM:</p><p><br></p><p>Memo To Users (Document 2023 changes to RGZPFM) <a href="https://www.ibm.com/docs/en/ssw_ibm_i_74/pdf/rzaq9.pdf" rel="noopener noreferrer" target="_blank">https://www.ibm.com/docs/en/ssw_ibm_i_74/pdf/rzaq9.pdf</a></p><p>RGZPFM - Basics on Reorganize While Active&nbsp;<a href="https://www.ibm.com/support/pages/node/684543" rel="noopener noreferrer" target="_blank">https://www.ibm.com/support/pages/node/684543</a></p><p>RGZPFM options and comparison&nbsp;<a href="https://www.ibm.com/support/pages/node/668043" rel="noopener noreferrer" target="_blank">https://www.ibm.com/support/pages/node/668043</a></p><p>Viewing Status of RGZPFM through IBM i Access Client Solutions&nbsp;<a href="https://www.ibm.com/support/pages/node/684643" rel="noopener noreferrer" target="_blank">https://www.ibm.com/support/pages/node/684643</a></p>

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

Guest Thumbnail

Kurt Schroeder

|IBM i GSC Support, Save Restore/BRMS
Guest Thumbnail

Alex Marquis

|IBM i GSC Support, Data Access

Today's Guests

HR

Holly Rademacher

|IBM i GSC Database Support