must reorganize huge file over thanksgiving
Home > IT Answers > AS/400 > must reorganize huge file over thanksgiving
DAIRYPGMR
20 pts.
0
Q:
must reorganize huge file over thanksgiving
CPYF, AS/400 Records, CLRPFM, AS/400 Record Reorganization
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: Nov 11 2008  8:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Slack400
1165 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Nov 13 2008  2:17 AM GMT by Slack400   1165 pts.
Latest Contributors: Bvining   4885 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

R.otto   435 pts.  |   Nov 12 2008  9:57AM GMT

Why don’t you use RGZPFM?

Rudolf

 

Gilly400   23625 pts.  |   Nov 12 2008  12:31PM GMT

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.

 

Philpl1jb   24600 pts.  |   Nov 12 2008  2:06PM GMT

When you RGZPFM or cpyf into your file DBMS will rebuild all the logicals — that may take the longest.

 

MDratwa   285 pts.  |   Nov 12 2008  4:31PM GMT

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.)

 
0