You, Me, and IBM i lives at the intersection of wit and wisdom, and offers an inside look at the lives of the technical support experts at the IBM i Global Support Center. Each episode explores a new aspect of support, and leaves listeners better able to solve their own issues and get back to business.
Alex Marquis (marquis@us.ibm.com) and Kurt Schroeder (kschroe@us.ibm.com) welcome your comments, questions, and show suggestions.
You, Me, and IBM i lives at the intersection of wit and wisdom, and offers an inside look at the lives of the technical support experts at the IBM i Global Support Center. Each episode explores a new aspect of support, and leaves listeners better able to solve their own issues and get back to business.
Alex Marquis (marquis@us.ibm.com) and Kurt Schroeder (kschroe@us.ibm.com) welcome your comments, questions, and show suggestions.
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