CDC for DB2/400
Description
The CDC for DB2/400 tool is used to enable Change Data Capture (CDC) on source DB2/400 tables.
It offers the possibility to enable trigger based CDC or native mode CDC on source tables.
Refer to Getting started with CDC for DB2/400 for more information.
Properties
Property | Mandatory | Description |
---|---|---|
Historize All Data |
false |
When this option is selected, the CDC table is loaded with all the data corresponding to the modifed lines. When the option is not selected, only the primary key or alternative key columns of the changed lines are loaded into the CDC table. When used in a mapping, the data is recreated by joining the source table to the CDC table. |
Cdc Operation |
false |
Defines the operation that the tool should perform. Possible options are:
|
Subscriber |
false |
Name of the subscriber to be created/deleted. The same name should be used on the mappings/processes that are supposed to consume the changed data from the CDC table. |
With Key |
false |
Defines the key that should be used to join the source table when the Historize All Data property is not set. Possible options are:
|
Capture Method |
false |
Defines the capture methods to use. Possible options are:
|
Boundary Calculation Method |
sequence-based |
Defines the methods used to calculate the boundaries when retrieving journal data. The possible options are:
|