The replcheck_stat_node Table
The replcheck_stat_node table contains the progress information for the consistency check and synchronization operations with progress report task names on a particular replication server.
Column | Type | Purpose |
---|---|---|
replnode_replcheck_id | integer | Server group ID (CDR ID). |
replcheck_node_id | integer | Unique key for the task, replicate, and server combination. |
replcheck_order | integer | A number to provide consistent ordering for display purposes. |
replcheck_node_name | varchar(128) | The name of the replication server. |
replnode_table_owner | varchar(128) | The owner of table being synchronized or checked. |
replnode_table_name | varchar(128) | The name of the table being synchronized or checked. |
replnode_row_count | integer | The number of rows in the participant. |
replnode_processed_rows | integer | The number of rows processed to correct inconsistent rows. |
replnode_missing_rows | integer | The number of rows on the reference server that do not exist on the target server. |
replnode_extra_rows | integer | The number of rows on the target server that do not exist on the reference server. |
replnode_mismatched_rows | integer | The number of rows on the target server that are not consistent with the corresponding rows on the reference server. |
replnode_extra_child_rows | integer | The number of child rows that required processing on the target nodes. |