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