1. Microservices Architecture Documentation
  2. Prepare
  3. Prepare Databases
  4. Db2 for i
  5. Preparing the Journals for Data Capture by Extract
  6. Setting Journal Parameters

Setting Journal Parameters

To support the capture of data by the Extract process, the following are the minimal journaling parameter settings that are required.

  • Manage Receivers (MNGRCV): *SYSTEM

  • Delete Receivers (DLTRCV): *NO

  • Receiver Size Option (RCVSIZOPT): *MAXOPT2 (*MAXOPT3 recommended). Oracle GoldenGate fully supports either option.

  • Journal State (JRNSTATE): *ACTIVE

  • Minimize Entry Specific Data (MINENTDTA): *NONE

  • Fixed Length Data (FIXLENDTA): *USR

In the following example, the command to set these attributes for a journal JRN1 in library LIB1 would be: 

CHGJRN JRN(LIB1/JRN1) MNGRCV(*SYSTEM) DLTRCV(*NO) RCVSIZOPT(*MAXOPT3) JRNSTATE(*ACTIVE) MINENTDTA(*NONE) FIXLENDTA(*USR)

Note:

To check the attributes of a journal, use the command WRKJRNA JRN(LIB1/JRN1) DETAIL(*CURATR).

When the journaling is set to the recommended parameter settings, you are assured that the entries in the journals contain all of the information necessary for Oracle GoldenGate processing to occur. These settings also ensure that the system does not delete the journal receivers automatically, but retains them in case Extract needs to process older data.