Skip to main content Skip to complementary content
Announcements

Activity tab

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

The last operation displayed is the last transaction occurred on this table.

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

 

Status

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

  • Hold: This table is held.

  • Run: The replication is being processed.

  • EndJrn: The last post for the journal (end journal) is reached.

  • Error: An error occurred.

  • No status is displayed:

    This table is a new table added after the engine start. You must restart the distribution to support this new table.

Control

Control starts, stops or terminates the distribution manually.

Information noteNote: 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.

 

Counters

These values are the totals of the values of the table, 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.

Values Description
Read

This specifies the number of sequences read in the journal.
Selected

This is the number of sequences selected in the journal as they concern the current table.
Sent This is the number of sequences sent to the target.
Ignored

This is the 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 This is the number of sequences added to the target.
Modified

This is the number of sequences modified on the target.
Deleted

This is the number of sequences deleted on the target.
Member op.

This is the 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

This is the number of sequences repaired on the target.
Errors

This is the number of errors found on the target.

Last operation

This 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.

Property Description
Receiver

This is the name and number of the receiver and its order number for Talend Change Data Capture within brackets.
Sequence number This is the 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

This is the 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)

This is the 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)

This is the name of the program that performed the I/O.
Sequence table This is the 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) This is the physical number of the record on which the I/O was performed.
Transaction ref.(non AS/400 IBMi source)

This is the reference of the transaction number on which the I/O was performed.
Process date

This is the 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

This is the internal code for the ongoing steps for the selected sequence.

  •     :    Sequence read.

  •     :    Error on the target.

  •     :    Sequence fully processed.

  • …

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 – let us know how we can improve!

Leave your feedback here