The syscdr_state table contains status on Enterprise
Replication, data capture, data apply, and the network between the
servers.
| Column |
Type |
Description |
| er_state |
char(24) |
The status of Enterprise Replication:
- Abort = Enterprise Replication is aborting on this server.
- Active = Enterprise Replication is running normally.
- Down = Enterprise Replication is stopped on this server.
- Dropped = The attempt to drop the syscdr database failed.
- Init Failed = The initial start-up of Enterprise Replication on
this server failed, most likely because of a problem on the specified
global catalog synchronization server.
- Initializing = Enterprise Replication is being defined.
- Initial Startup = Enterprise Replication is starting for the first
time on this server.
- Shutting Down = Enterprise Replication is shutting down on this server.
- Startup Blocked = Enterprise Replication cannot start because
the server was started with the oninit -D command.
- Synchronizing Catalogs = The server is receiving a copy of the syscdr database.
- Uninitialized = The server does not have Enterprise Replication
defined on it.
|
| er_capture_state |
char(24) |
The current state of log capture:
- Running = Log capture is running normally
- Down = Log capture is not running
- Uninitialized = The server is not a source server for replication
|
| er_network_state |
char(64) |
The status of the Enterprise Replication network:
- Running = Communication is running normally
- Down = Communication is not running
- Uninitialized = The server is not a source server for replication
|
| er_apply_state |
char(24) |
The status of the receive manager and apply threads:
- Running = Transaction apply is running normally
- Down = Transaction apply is not running
- Uninitialized = The server is not a source server for replication
|