To print the current status of C Replicator (CREP) replication subscriptions, use the following command, see REPLICATOR:
ADMIN COMMAND 'replicator status'
A subscription can have one of the following states:
▪ INIT: Initial state when the subscription is created.
▪ LOAD: Data load is running.
▪ ACTIVE: Online replication is active.
▪ STOPPED: Replication subscription is stopped by user command.
▪ ERROR: Replication subscription could not recover automatically from an error situation (for example data conflict or loss of the source connection), or replication subscription has not started due to error.
For example:
> replicator status '#0 ''TEST_PART_01'' - ACTIVE Last connected: 2018-04-20 12:21:43.0 Last error: <NONE> Last error time: <NEVER> '
'#1 ''TEST_PART_02'' - STOPPED Last connected: 2018-04-20 12:04:48.0 Last error: <NONE> Last error time: <NEVER> '
> replicator status TEST_PART_02 'STOPPED Last connected: 2018-04-20 12:04:48.0 Last error: <NONE> Last error time: <NEVER> '
You can also use the DESCRIBE REPLICATION STATUS statement, see DESCRIBE REPLICATION.