Activity tab - 7.3

Talend Change Data Capture Reference 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-11-09

This tab is used to observe the activity and to start or stop the selected distribution.

The activity is refreshed according to the value specified in the Supervise/Refresh time delay option in the main menu.

 

Status

This parameter specifies the current distribution status if it is ongoing, or the last status if it has stopped.

Statuses can be of the following types:

  • Init: The engine is starting
  • Run: The engine is processing
  • EndJrn: The engine has reached the end of the journal
  • Error: There has been an error

Control

This parameter starts, stops or terminates the distribution manually.

Note: If the distribution is supervised by the Scheduler, the Scheduler can stop or start the distribution automatically according to its own schedule, independently of your manual start/stop action.

A window is displayed informing you that your action was taken into account. It may not be applied immediately, as a waiting period may be observed. This is normal.

 

Counter

These values are the totals of the values of the model tables, and are given for informational purposes only. 

They are reset each time a replication session starts. If the session is recovered from a previous session that was aborted, the counters are not reset.

Value Description
Read Specifies the number of sequences read in the journal.
Selected Number of sequences selected in the journal as they concern the current model.
Sent Number of sequences sent to the target.
Ignored

Number of sequences ignored and not sent to the target. 

The sequences that are ignored can be omitted either by defining them in the parameters, or by using the transformation module.

Added

Number of sequences added to the target.

Modified Number of sequences modified on the target.
Deleted

Nnumber of sequences deleted on the target.

Member op.

Number of member operations performed on the target. 

A member operation is a CLRPFM, RGZPFM, or similar instruction for an AS/400 IBMi source, and a clean up with extraction for the other sources.

Repaired

Number of sequences repaired on the target.

Errors Number of errors found on the target.

Last operation

This parameter provides information about the last operation recorded in the journal. 

This may not necessarily be the last operation transmitted, but rather the last sequence recorded in the journal.

Sequence type Description
Receiver

Name and number of the receiver and its order number for Talend Change Data Capture within brackets.

Sequence number

Order number of the sequence in the receiver.

Sequence type

Sequence types have the following attributes:

Sequence type Description
F/CR Clear the file (AS/400 IBMi)
F/RZ Reorganize the file (AS/400 IBMi)
F/RM Delete a member (AS/400 IBMi)
R/PT Add a record
R/UB Image before an update
R/UP Image after an update
R/DL Delete a record
: : Non-exhaustive list
Sequence date

Date and time of the sequence. 

This is the exact date and time of the I/O in the database on the source.

Sequence Job (AS/400 IBMi source)

Name of the AS/400 IBMi Job that performed the I/O. 

It is composed of the Job number/User/Job name.

Sequence program (AS/400 IBMi source) Name of the program that performed the I/O.
Sequence table

Name of the AS/400 IBMi file or the Oracle, SQL Server, ODBC table in which the I/O was performed.

Sequence RRN (AS/400 IBMi source) Physical number of the record on which the I/O was performed.
Transaction ref.(non AS/400 IBMi source) Reference of the transaction number on which the I/O was performed.
Process date

Date and time when the transaction was taken into account (step 0) and/or replicated (step 9) by Talend Change Data Capture. The date/time is that of the source machine and actually contains the date/time of receipt of the acknowledgement for the processing on the target machine (which is therefore earlier than the date/time displayed).

Step

Internal code for the ongoing steps for the selected sequence.

  • 0: Sequence read.

  • 8: Error on the target.

  • 9: Sequence fully processed.

  • …