1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Db2 for i
  5. Preparing the System for Oracle GoldenGate
  6. Preparing the Journals for Data Capture by Extract
  7. 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 to avoid the necessity to perform an ALTER EXTRACT with the ETROLLOVER option when the journal sequence numbers run out if *MAXOPT2 is used.)

  • 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.