RGZPFM with ALWCANCEL(*YES)

bogeybetsy

560 pts.

Tags:

IBM i

Journaling

RGZPFM

V7R1

We want to reorg our files to reclaim deleted record space. Since for High Availability, all our files our journaled, we run RGZPFM with ALWCANCEL(*YES) to minimize planned downtime reorgs. If journal receivers take up more space than the amount of storage we save from reclaiming deleted record space, then there really is no point in the RGZPFM with ALWCANCEL(*YES), is there?

Software/Hardware used:
IBM i V7R1

Asked: May 5, 2011 8:04 PM Last updated: May 5, 2011 9:26 PM

Answer Wiki

Last updated: May 5, 2011 8:12 PM GMT

CharlieBrowne62,340 pts.
History
Contributors
- Ordered by most recent
- CharlieBrowne62,340 pts.

Thanks. We'll let you know when a new response is added.

IT depends on how long you keep your receivers on the system.
If at the end of the REORG, you have the same amount of disk space used, but in a few days, you copy the receivers off the system and then remove them, you will get the space back taht you want.
Are you going to change your PF to be REUSTDLT(*YES)?

Discuss This Question: 2 Replies

TomLiotta May 5, 2011 9:26 PM GMT

If journal receivers take up more space than the amount of storage we save from reclaiming deleted record space, then there really is no point in the RGZPFM with ALWCANCEL(*YES), is there? First, there probably shouldn't be any significant recovery of deleted space. As CharlieBrowne mentioned, the files (probably) should have the REUSTDLT(*YES) attribute set so there wouldn't be much of anything to recover in terms of space. Next, the purpose of ALWCANCEL(*YES) is to enable a "Cancel" capability (along with a potential "Restart where you left off" capability). The journaling is what allows this to work. Also, especially in a HA environment, the relaxation for LOCK(*EXCL) when ALWCANCEL(*YES) is used might be much more important than any space savings. Finally, without the journaling, the physical reorganization is apparently done in temporary database objects. Those would take up space just as journal receivers do while the reorg is running. Overall, it's hard to see how a comparison of recovered deleted record space and journal receiver size is related. Tom

125,585 pointsBadges:

report
The Most-Watched IT Questions: May 17, 2011 - ITKE Community Blog May 17, 2011 6:15 AM GMT

[...] TomLiotta and CharlieBrowne came together to help a member reorganize files in V7R1 to reclaim some record [...]

0 pointsBadges:

report