RGZPFM vs Reusing Deleted Records

20 pts.
Tags:
DASD
REUSEDLT
RGZPFM
Space allocation
Does anyone have an opinion on using one over the other? I am familiar with RGZPFM and it's benefits but am not familiar with the PF option of reusing deleted records...I would think it would be better to reorganize the file rather than reusing deleted records becuase you could have a lot of deleted records in the your file but that doesn't mean they are all being used... any advise on this matter is appreciated!!
ASKED: October 24, 2008  5:27 PM
UPDATED: October 27, 2008  2:40 PM

Answer Wiki

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

If you expect to find the records in the entry order you cannot use Reuse Deleted
Unless you use RGZPFM the file will always occupy the space of the largest number of active records

RGZPFM requires exclusive access to the file
RGZPFM will allow you to change the physical file sequence, which might speed up some access

Discuss This Question: 1  Reply

 
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
  • Cwc
    If you have a huge file that takes hours to reorganize, and you can't afford that much downtime with your application which uses it, reusing deleted records would be preferable. We have such a file in our application, and it takes a day or two to reorganize it. So, reusing works better for us, since new records are frequently added to the file, which reuses the space.
    4,290 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