Reduce Disk Space On IBM iSeries Using RGZPFM
Read Time:57 Sec
This isn’t news to many iSeries Admins or CNC Admins but it really hit home for me a couple weeks ago. We had a file that was really increasing to an unmanageable size (500+GB) and didn’t know why. It was the F00165 (Media Objects). There were only 500,000+ records and only a few thousand deleted records. We really couldn’t understand the massive amount of growth. Well, it turns out that one of our developers has a job running on the scheduler every 3 minutes which rights text log entries to the F00165. It doesn’t create a bunch of new records, it just appends entries to existing records. Not knowing if Reorganizing the file would help, we waited until after hours and ran the following:
RGZPFM FILE(PRODDTA/F00165)
The results were amazing! It dropped the file size to 770+MB! Yeah, that’s right MB!!!
That’s nuts, I agree. However, it made our infrastructure manager very happy and now we run that job nightly just to make sure we don’t need to deal with it again.
IBM iSeries RGZPFM Command: FAQs
IBM iSeries RGZPFM Command: Ending a RGZPFM
Average Rating