The syscdrprog Table

The syscdrprog table lists the contents of the Enterprise Replication progress tables.

The progress tables keep track of what data has been sent to which servers and which servers have acknowledged receipt of what data. Enterprise Replication uses the transaction keys and stamps to keep track of this information.

The progress table is two dimensional. For each server to which Enterprise Replication sends data, the progress tables keep progress information on a per-replicate basis.
Column Type Description
dest_id integer Server ID of the destination server
repl_id integer The ID that Enterprise Replication uses to identify the replicate for which this information is valid
source_id integer Server ID of the server from which the data originated
key_acked_srv integer Last key for this replicate that was acknowledged by this destination
key_acked_lgid integer Logical log ID
key_acked_lgpos integer Logical log position
key_acked_seq integer Logical log sequence
tx_stamp_1 integer Together with tx_stamp2, forms the stamp of the last transaction acknowledged for this replicate by this destination
tx_stamp_2 integer Together with tx_stamp1, forms the stamp of the last transaction acknowledged for this replicate by this destination

Copyright© 2018 HCL Technologies Limited