Column name | Description |
Replication | This is the name of the source table followed by the name of the target table. |
State Description | This tells the current state of the replication. See below for a complete list of State Descriptions. |
Initial State Start | This is the date and time the last initial state was started for this replication. |
Initial State End | This is the date and time the last initial state ended. |
Total (HH:MM:SS) | The total time the last initial state took for this replication. |
Messages | If there are any error messages associated with this replication, they will be displayed here. You can double click on this field to display the entire message in an edit box for easier reading. |
Statistic | Description |
Consumer start date | The day and time the consumer first started replicating after a deploy. |
Status Interval length | The length of time in seconds for which statistics are gathered before recording them. Set in the registry on the controller. |
Statistics Totals | Consumer Since Start - These are the total values collected since the engine was started with the first deploy. Last Interval - These are the total values collected during the last statistics recording interval (as set by the CTRL_PERF_QUERY_INTERVAL registry setting). |
Statistics Rates | Consumer Total - These are the rates for this consumer. Rates are determined as amount per second. Record Loader (i) - These are the rates for each Record loader that the consumer is running. The number of Record loaders is set in the Replication administrator Config Servers screen with the "Parallel transaction count". |
Initial States | The number of initial states processed by this consumer. |
Transactions | Number of transactions the consumer has processed and committed to the target. |
Rows Processed | Number of individual rows processed by the consumer and sent to the target. |
Events | Number of messages from the source processed and sent to the target by the consumer. |
Inserts | Number of rows inserted into the target by the consumer. |
Updates | Number of rows updated in the target by the consumer. |
Deletes | Number of rows deleted in the target by the consumer. |
Errors | Number of errors recorded during replication by the consumer. |
State | Description |
Replicating | Active and replicating. |
Not replicating - offline | This indicates that either the target database has gone down or replication has been stopped by pressing the Stop Targets button (see below). This is a Consumer status message. |
Replication offline | This indicates that an individual replication is offline either due to an unrecoverable error on the target or due to pressing the Stop Targets button (see below). This is a Replication status message. |
Processing Initial State... | On the Consumer, this indicates that it is processing initial states. Each replication that is actively being processed will also indicate this status. |
Initial State Pending | This indicates that an initial state has been requested for a replication, but it has not started yet. |
Initial State Complete | This indicates that an initial state has finished for this replication but the overall process has not yet been completed by the Event Consumer. Once all pending initial states have completed, the consumer and all replications with a successful initial state will go to a Replicating status. |
Initial State Failed | This indicates that an error occurred during initial state processing. Check the Messages field for more information about the error. |
Deploy Failed | This indicates that an error occurred during the deploy process. Check the Messages field for all components for more information about the error. |
No Active Configuration | This indicates that nothing has been deployed to the controller. |
Status of the System Unknown/Unable to contact controller | This indicates that the Replication Administrator was not able to contact the controller to get status. Common causes of this message are the controller is not running or the message queues on either the Administrator machine, the EP machine or the controller machine are not running. |