Journalizing other databases
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
-
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:
-
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:
-
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.