RGZPFM with ALWCANCEL(*YES)

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
UPDATED: May 5, 2011  9:26 PM

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
  • bogeybetsy
    [...] TomLiotta and CharlieBrowne came together to help a member reorganize files in V7R1 to reclaim some record [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following