AS400 Journal Record Image

Record image is a journal way of recording to the journal receiver the data changes of a file. There are two types of image records:

  • *AFTER, journaling only records data after changing a file’s record.
  • *BOTH, journaling records data before and after changing a file’s record.

When to use * AFTER or * BOTH images?

Image * BOTH can be used for audit purposes (recording data before and after being changed). Because there is a recording of two data contents, the formed journal entries will be larger and consume disk capacity twice the image * AFTER.

Image * AFTER makes writing fewer journal entries to journal receivers. This image makes the audit process more difficult because it only records after the data has been changed.

Example file with journaling image * AFTER and * BOTH when updating records via STRSQL.

Record Image *BOTH:

SOOLDAT/TESTFILE file with journal images * BOTH. Data changes were made with STRSQL:

update SOOLDAT/TESTFILE set address=’Jakarta’ where name=’Bob’

The journal records two journal entries: R-UB (update before) and R-UP (update after).

Record Image *AFTER:

SOOLDAT/TESTFILE file with journal images * AFTER. Data changes were made with STRSQL:

update SOLDAT/TESTFILEset address=’Bali’ where name=’Bob’

Journal records one R-UP journal (update after) only.

Change Journal Record Image:

Through the command line, type CHGJRNOBJ then press F4 = Prompt. Press F9 = All Parameters to show all parameters.

Press page down until you find the Attribute (ATR) parameter. Enter the Attribute parameter: * IMAGES and Images parameter: *AFTER or *BOTH (as needed).

Note: For systems that have a fairly high database activity, images *AFTER are highly recommended. Because it will reduce disk I / O compared to using *BOTH.

Leave a Reply