Calling all AS/400 gurus : RGZPFM and REUSEDLT(*YES)

Hi all

We are currently running OneWorld B733.2 and World Cum 11 on an AS/400. We have reached 80% disk usage on our AS/400. In reviewing where this is used, we found two files in our data library (A73PRDDTA) that are 7GB (F0911R) and 5GB (F83UI001) in size. We have noticed that both files have a large number of deleted records. Both files appear to be workfiles, F0911R for the reconciliations on F0911, and F83UI001 for the drill-down from financial reports.

I have some questions that I would like help with:

1. is running RGZPFM (Reorganise physical file member) recommended/supported by JDE?
2. will running this command improve performance?
3. should we set these files to REUSEDLT(*YES), and is this recommended/supported by JDE?
4. can we do the same to other JDE files?
5. are there any restrictions on using these commands with JDE running on the AS/400?

By running the RGZPFM over these two files in each of our data libraries, we expect to recover over 20% of disk space.

We could recover even more disk space by running the RGZPFM over other files on the system, but are concerned about impacts this may have.

Any advice would be appreciated.

Thanks
Ian

We run a rgzpfm over the entire data base every Sunday and have done
since Aug '99. Our CL program (bit messy below because of a rough
copy/paste) excludes the F0911 and F4802 but does all other files if
more than 3500 deleted records. The two files missed on Sundays are done
during public holidays.


0016.00 DSPFD: DSPFD FILE(&LIB/*ALL) TYPE(*MBRLIST) +
000814
0017.00 OUTPUT(*OUTFILE) FILEATR(*PF) +
000814
0018.00 OUTFILE(QGPL/FILES)
000814
0019.00 MONMSG CPF0000
990113
0020.00
990113
0021.00 NEXTFILE: RCVF RCDFMT(QWHFDML)
990113
0022.00 ENDFILES: MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END
)) 990113
0023.00
001023
0024.00
001023
0025.00 F0911: IF COND(&MLFILE *EQ 'F0911') THEN(GOTO +
010204
0026.00 CMDLBL(NEXTFILE))
010204
0027.00
000329
0028.00 F4802: IF COND(&MLFILE *EQ 'F4802') THEN(GOTO +
010504
0029.00 CMDLBL(NEXTFILE))
010504
0030.00
010504
0031.00 OTHER: IF COND(&MLNDTR *LT 3500) THEN(GOTO +
001023
0032.00 CMDLBL(NEXTFILE))
000329
0033.00
990113
0034.00 RGZ: RGZPFM FILE(&MLLIB/&MLFILE) MBR(&MLNAME)
990113
0035.00 MONMSG CPF0000
990113


F3=Exit F4=Prompt F5=Refresh F9=Retrieve F10=Cursor
F11=Toggle


Regards
Max Brown

All of your questions/suggestions are great ideas and supported by JDE =
and IBM.


If you have files from World, you can also check files and logicals for =
access path size. World tables are 4GB where new OW tables usually get =
created at 1TB (much better). You can change the table manually but =
make sure it is not in use or have an object lock.


Trish Sutterfield
Cell 678-576-6201
[email protected]

1. RGZPFM is supported by IBM, not an issue to JDE. Has to be run when no one will use the file.
2. Running the command will improve performance
3. watch using the REUSEDLT records parameter, some programs, like the post for F0911 records, expect the records to be in correct physical sequence when added.
4. I would use the RGZPFM on any file with 10% deleted records, though the F0911 may take a long time to reorganize and should be done when the system is down.
5. JDE support the use the REUSEDLT as far as I know.

Ian

I agree with the others - we do RGZPFM once a month. Also, you may want to have a look at www.search400.com and enter RGZPFM in the search. Some handy stuff there.

Malcolm

Thanks to everyone for their comments.

I don’t really want to single anyone out, because everyone’s comments were helpful, but I do want to thank Max for the copy of the CL program and Malcolm for the link to www.search400.com – very handy tips !

Just to close out this thread, I also received the following response from JDEdwards GSS:

"After reviewing the question with one world and world it was concluded that you can run the RGZPFM (Reorganize Physical file member) and modify file parameters with REUSEDLT(*YES). Before you attempt to reorg we suggest that you have full backup."

I also received the following response from Perry offline:

"its available to any AS/400 defined table, including jde tables. jde already sets up all their tables w/"reusedlt" to avoid the reorganize requirement by AS/400 users so would be surprised if the 2 aforementioned aren't already set up with that setting? I've used it for a long time and have had no problems w/JDE defined tables... slight performance gains should be achieved since less overhead on the OS algorithm to use the deleted records as well as increasing disk space. So use of the command should have no impact."

Once again, thanks everyone.

Cheers
Ian