Skip to main content

AS/400 IBMi database

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 journalization of an AS/400 IBMi database must be carried out by a Database Administrator (DBA) with the AS/400 IBMi tools.

Talend Change Data Capture directly uses the AS/400 IBMi logs. The journalization of other databases depends on the type of database and of the installation. This determines the principle used to capture the transactions in the Talend Change Data Capture journals that are available independently of the nature of the database. Nevertheless, there could be many types of journals, i.e, ones expressly for backup purposes or for more general use. This depends on the type of database.

For further details, contact Talend Support.

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.

Information noteNote: To activate automatic management of the journal receivers by IMBi, 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.

The following sequence is used for creating a journal and journalizing a file:

  1. Create the AS/400 IBMi journal receiver, JRNRCV0001, in the BIBJRN library. 
    CRTJRNRCV JRNRCV(BIBJRN/RCV0000001)
    Information noteNote: It is recommended to end the journal receiver's name with at least 4 digits (0001) so that IMBi 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.
    Information noteWarning: It is strongly recommended 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.
  2. Create the AS/400 IBMi journal: 
    CRTJRN JRN(BIBJRN/JOURNAL)

JRNRCV(BIBJRN/RCV0000001)
  3. Journalize the AS/400 IBMi file BIBFIC/FIC1: 
     STRJRNPF FILE(BIBFIC/FIC1) JRN(BIBJRN/JOURNAL) IMAGES(*BOTH) OMTJRNE(*OPNCLO)
    Information noteNote: 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 (use the WRKOBJLCK command to make sure it is not used).

In this section

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here