Journalizing other databases - 7.3

Talend Change Data Capture User Guide

Version
7.3
Language
English
Product
Talend Change Data Capture
Module
Talend Change Data Capture
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2023-12-22

About this task

The Talend Change Data Capture journal is a file named after the database or the schema name with the extension .JRN. It is used to record the modifications made to files. The journal contains the characteristics of the current journalization task. For example, the journal of the MYDATA database would be called MYDATA.JRN. The Talend Change Data Capture journal receiver is a file associated with the journal. It contains the data relative to the changes made to the database. Its name is composed of the journal's name followed by a number sequence, and its extension is .JRNRCV. For example, the first journal receiver in the MYDATA database would be named MYDATA_0000000001.JRNRCV.

When the journal receiver size nearly reaches the MaxRcvSizeMo parameter, it is replaced by a new journal receiver that is created automatically. The Talend Change Data Capture DDJRN command is used to automatically delete the receivers that are no longer used.

The procedure to create a journal and journalize a file is as follows:

Procedure

  1. Use Talend Change Data Capture to journalize a non-AS/400 IBMi database. In the main menu, select the Journal management option from the Source menu.
    The following window is displayed:
  2. Select the ADVENTURE database, then right-click and choose the Start DB journalization option from the context-sensitive menu.
    The following window is displayed in which you can choose the journal storage directory:
  3. On disk D, select the DD_JOURNAL\INST1 directory that you created during the installation. When the journalization process is in progress, messages specifying the ongoing phase are displayed. Note that when it is completed, the icon against the ADVENTURE database is different. This means that it is journalized for Talend Change Data Capture.
  4. To journalize one or more tables, select them in the list and then right-click to display the context-sensitive menu to choose the appropriate option.
    You can hold the transaction log capture by selecting the Hold check box.