must reorganize huge file over thanksgiving

20 pts.
Tags:
AS/400 Record Reorganization
AS/400 Records
CLRPFM
CPYF
We have a file with 4 million active records and 200 million deleted records , I want to reorganize on Thanksgiving. Plan is to copy out (cpyf) , clrpfm, then copy back (cpyf). My question is will the 'clrpfm' run for hours ??
ASKED: November 11, 2008  8:22 PM
UPDATED: November 13, 2008  2:18 AM

Answer Wiki

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

If you have logicals over this file, you may want to change the “Access path maintenance” to “*dly”. This will allow the “RGZPFM” to run faster because the access path will not be update during the reorg. After it finishes, submit the change to the logicals “Access path maintenance” to “*immed” (or what they were before). Hopefully noone or not job will open the logicals until they finish or they will be waiting a while. If you submit all of the jobs to batch with a jobq that runs one at a time you will not have to watch them run. (If you have a job that will email/page you, you could submit it last and then you will know when it is done.)

MDratwa’s response get’s promoted.

the ‘no’ answer was lame and not helpful.

I say RGZPFM.

You need to make sure the file is flagged to reuse deleted records otherwise it’s isn’t going to help much.

Try scheduling this reorg to run every few weeks and it will run faster

Discuss This Question: 4  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
  • r.otto
    Why don't you use RGZPFM? Rudolf
    810 pointsBadges:
    report
  • Gilly400
    Hi, Bvining is correct - the CLRPFM will be very quick. The CPYF's will take longest to run. I suggest you do a CHGPF of your file to re-use deleted records :- CHGPF yourlib/yourfile REUSEDLT(*YES) This will avoid deleted records in the future - check that your application programs don't get affected by doing this beforehand (maybe your application needs records in arrival sequence). Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • philpl1jb
    When you RGZPFM or cpyf into your file DBMS will rebuild all the logicals -- that may take the longest.
    48,545 pointsBadges:
    report
  • MDratwa
    If you have logicals over this file, you may want to change the "Access path maintenance" to "*dly". This will allow the "RGZPFM" to run faster because the access path will not be update during the reorg. After it finishes, submit the change to the logicals "Access path maintenance" to "*immed" (or what they were before). Hopefully noone or not job will open the logicals until they finish or they will be waiting a while. If you submit all of the jobs to batch with a jobq that runs one at a time you will not have to watch them run. (If you have a job that will email/page you, you could submit it last and then you will know when it is done.)
    785 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