CDC Guide for i5/OS

10.5.2
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring DB2 Journaling for Change Data Capture

To register tables for capture, you must configure tables and physical files to write before and after images to journals. PowerExchange reads change data from journals and requires both before and after images to properly process change data.

You can capture changes from local or remote journals.

Use the following DB2 for i5/OS command to start journaling for a physical file for which you want to capture change data:

STRJRNPF FILE(library/file) JRN(jlib/jfile) IMAGES(*BOTH) OMTJRNE(*OPNCLO)

The following table describes the parameters in this command:

Parameter	Description
library/file	Library and physical file for which changes are written to the journal.
jlib/jfile	The library and journal to which changes are written.
IMAGES(*BOTH)	Before and after images are written to the journal.
OMTJRNE(*OPNCLO)	Open and close entries are omitted from the journal.