The CDC Configuration section of the synonym properties which are created for a Table Log.
Note: Each permitter has a default value of a global variable whose name begins with &&CDC_ and is followed by the parameter name. Normally you would just type over or select a value to replace the default with a constant value, then save the synonym.
Alternatively the values could be set dynamically in a process flow in a "Set variables" object.
The following options are available:
This is set to DBMSLOG to indicate the origin of the data is a DBMS Table Log.
Indicates the starting point for reading log records.
Indicates if the last processed transaction should be saved in the checkpoint file.
Indicates the location and name of a file to use to store checkpoint information in a:
The following three parameters, LOG_NAME, LOG_LOCATION, and COMMIT_MODE are available on iSeries platforms only, with DB2 database. These parameters can be used when the requirement is to use a non-standard journal and/or a non-current location (for example, alternate library), where the journal and location that are explicitly manually defined by a database administrator (versus a CREATE COLLECTION). One example would be a requirement to use a remote journal, instead of the local one.
Indicates the name of the journal.
Indicates the location name.
Supports the transactional commitment control.
Indicates the polling interval in seconds, how often the database log is scanned. Default is 1 second.
Indicates the timeout interval in seconds. If there is no activity in this time interval, the processing will stop. A value of zero means there is no limit. The default value is 1 second.
Note that the two options above work together. For example, if POLLING is 2 and TIMEOUT is 10, the server polls the log every 2 seconds for new transactions. If there are no new transactions after 10 seconds, then polling stops.
Indicates maximum number of database transactions to process before stopping the job. A value of zero (0) means all transactions. The default value is 1 transaction.
Note: For normal Change Data Capture processing, specify a location for CHKPT_FILE so that checkpoint information and set CHKPT_SAVE to YES. Then set START to CHKPT so that processing starts at the last saved checkpoint.
However, note that any operation that reads from the log table including "Test Transforms," resets the checkpoint. In that case, a test transform uses the data and that data is no longer available to subsequent runs of the data flow.
iWay Software |