Setting up CDC in Redo/Archive log mode (journal) for AS/400 - Cloud - 8.0

Talend Data Fabric Studio User Guide

Version
Cloud
8.0
Language
English (United States)
EnrichDitaval
Data Fabric
Product
Talend Data Fabric
Module
Talend Studio
Content
Design and Development

In the AS/400 Redo/Archive log mode, Talend Studio runs its AS/400-dedicated RUNCDC program to read and analyze journals and receivers, extract change information from the source table, create a CDC table in the CDC library based on the same name as the source table, update the CDC table (the change table) and make queries on the changes. Both the long name and the short name of a source table are used but only the short name is used to name the CDC table.

The default mode of RUNCDC is set to DETACHED, and the tAS400CDC component only reads detached journals. The command CHGJRN JRN(<Source_library_name>/<Journal_name>) JRNRCV(*GEN) is used to ensure that an older receiver is detached from a journal and a newer one is attached to the journal to retrieve the last change. You are then recommended to execute this command in your AS/400 system before running the tAS400CDC component. Alternatively, you can use a custom command through the tAS400CDC component to automate this process. For more information, see Extracting the change data modified in AS/400 journal mode.

Talend Studio does not automatically create, modify or delete any journal and can only run the CDC process on the basis of the journal and receivers that you or the administrator of your AS/400 system can provide depending on the policy of your company. For this reason, ensure that an old receiver has been treated by RUNCDC before deleting it so as to avoid lost of the information recorded in that receiver.

Warning:
  • Avoid data replication on your AS/400 system during the execution of the RUNCDC program.
  • The DLTRCV(*YES) parameter should not be used in the CHGJRN command, or else all detached receivers will be deleted after the journal is detached and the RUNCDC program cannot read the logs.