Journalizing AS/400 IBMi database - 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 AS/400 IBMi journal is a standard AS/400 IBMi object (*JRN) used to record the modifications made to files. The journal contains the characteristics of the current journalization task. The AS/400 IBMi journal receiver is an AS/400 IBMi component (*JRNRCV) associated with the journal. It contains the data relative to the changes made to the database.

To activate automatic management of the journal receivers by IBMi, assign a maximum size (expressed in kB). When the maximum size is reached, the receiver is detached and a new one is assigned automatically. The Talend Change Data Capture DDJRN command is used to automatically delete the receivers that are no longer used.

Procedure

  1. To activate automatic management of the journal receivers by IBMi, assign a maximum size (expressed in kB). When the maximum size is reached, the receiver is detached and a new one is assigned automatically. The Talend Change Data Capture DDJRN command is used to automatically delete the receivers that are no longer used.
  2. Create the AS/400 IBMi journal receiver, JRNRCV0001, in the BIBJRN library.
    CRTJRNRCV JRNRCV(BIBJRN/RCV0000001)
    Note: It is recommended to end the journal receiver's name with at least 4 digits (0001) so that IBMi can continue the numbering if the receivers are managed automatically. Talend Change Data Capture uses this function to determine a receiver's position with respect to another receiver. We strongly recommend that you do not change this order by inserting a receiver without a number, or a receiver with a lower number. If, despite these precautions, the order is broken, you can solve the problem by making recoveries from a sequence.
  3. Create the AS/400 IBMi journal:
    CRTJRN JRN(BIBJRN/JOURNAL)
    JRNRCV(BIBJRN/RCV0000001)                
  4. Journalize the AS/400 IBMi file BIBFIC/FIC1:
    STRJRNPF FILE(BIBFIC/FIC1) JRN(BIBJRN/JOURNAL) IMAGES(*BOTH) OMTJRNE(*OPNCLO)
    Warning: Make sure that the files are journalized with *BOTH images and not *AFTER images, which is the default value proposed.
    You can continue to use a file that is being journalized. However, when you stop journalizing a file (ENDJRNPF command), the file must not be used (you can ensure this by using the WRKOBJLCK command).