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