AS/400 file reorganization/journaling
Should journaling be stopped before a very large file is reorganized?
Software/Hardware used:
AS/400 iSeries
Software/Hardware used:
AS/400 iSeries
ASKED:
September 8, 2011 4:14 PM
UPDATED:
March 31, 2012 4:58 PM
Answer Wiki:
NO
It will only write one entry to the journal.
RG Physical file member reorganized (RGZPFM)
To see all answers submitted to the Answer Wiki: View Answer History.
Actually, for some large-file reorganizations, journaling needs to be active. Specifying RGZPFM ALWCANCEL(*YES) requires journaling to be active. See message ID CPF3181 for a reference.)
Tom
If all answers could be this easy ..
It depends on which kind of options you use for the reorg. If you are reorganizing while other programs can still access the file then the story is a little bit different.
When doing an exclusive reorg you will basically create a copy without the holes left by the deleted records and the copy will then replace the original file.
In all other cases the system will shift all records after the first hole to get a continuous file. This method implies lots of inserts and deletes and ………. journal entries. Stopping journalling is an option, but another option to look at is journal caching. Journal caching is changing the way the receivers are physically being written to disk. Normally receivers are written record by record (FORCEWRITE is ON), but with journal caching it will be blockwise and thus less physical writes to disk. BE CAREFUL about this option as the receivers now stay in cache longer and in case of a system failure transactions WILL go missing.