AS/400 file reorganization/journaling

Tags:
AS/400 administration
AS/400 File Sharing
AS/400 journaling
Journaling (AS/400)
Should journaling be stopped before a very large file is reorganized?

Software/Hardware used:
AS/400 iSeries
ASKED: September 8, 2011  4:14 PM
UPDATED: March 31, 2012  4:58 PM

Answer Wiki

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

NO
It will only write one entry to the journal.
RG Physical file member reorganized (RGZPFM)

Discuss This Question: 2  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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • AdrianF
    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.
    145 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