This Article seeks to de-obsfucate the mysteries of DSRUTIL STATUS vs -detail (or verbose) in the Tables return codes:
Use Database Replication: User Guide": Reference, DSRUTIL status qualifier
- When the detail or verbose argument is used: [Table 1. Detail and Verbose return codes]
https://docs.progress.com/bundle/openedge-database-replication/page/When-the-detail-or-verbose-argument-is-used.html
- When the detail or verbose argument is not used: [Table 1. Return code zero status code]
https://docs.progress.com/bundle/openedge-database-replication/page/When-the-detail-or-verbose-argument-is-not-used.html
When "dsrutil dbname -C status" is used, only the "Status" codes are returned. These are essentially a pre-fixed "Group Status Code":
1101 : DSRUTIL source -C status
2101 : DSRUTIL source -C status agent1
3101 : DSRUTIL target -C status
These are further outlined in Article: OE Replication reference DSRUTIL STATUS group and detail codes
When "dsrutil dbname -C status -detail" (or verbose) is used, only the "Detail Status" codes are returned, which are a sub-set of the group status's:
6021 : DSRUTIL source -C status -detail
3049 : DSRUTIL source -C status agent1 -detail
1063 : DSRUTIL source -C status agent2 -detail
It's important to understand the difference between these two sets (a set and a sub-set) as together they provide a fuller picture of the replication status quo. For example, For the the status group "101 Processing" above, detail provides a finer granularity of what-processing is taking place like:
- RPLS 6005 | RPLA 3048 Startup Synchronization
- RPLS 6021 | RPLA 3049 Normal Processing
- RPLS 6004 | RPLA 3050 Recovery Synchronization
The following list provides this detail re-grouped by focus (ie source or target or source to agent).
Using "DSRUTIL -C status verbose" will provide both the status code and description to record status pages
Server to Agent initial connect status codes
1001 Initial Connection
1002 Initialising
1003 Target in Quiet Point
1032 Initial Connection Failed
1033 Recovery Failed
1034 Invalid Target Database Configuration
1035 Agent Failed
1036 Agent is Ignored
1037 Agent is Stopped
1038 Agent is Terminated
1063 Agent is Ended
Replication Server
1100 connecting status
1101 processing status
1102 stalled status
1103 pre_transition status
1104 listening status
1105 transition status
1199 inactive
1255 unknown
6001 Server Initialisation
6002 Connecting to Agent(s)
6003 Configuring Agent(s)
6004 Recovery Processing
6005 Startup Synchronization
6006 Initiating Agent to Agent Connections
6021 Normal Processing
6022 Performing Transition
6023 Replication is Suspended
6060 Server is ended
Control Agent
2100 connecting status
2101 processing status
2102 stalled status
2103 pre_transition status
2104 listening status
2105 transition status
2080 Pre Transition
2081 Applying After-image Extent
2082 Transitioning
2083 Listening
2199 inactive
2255 unknown
Agent
3100 connecting status
3101 processing status
3102 stalled status
3103 pre_transition status
3104 listening status
3105 transition status
3048 Startup Synchronisation
3049 Normal Processing
3050 Recovery Synchronisation
3051 Being Transitioned
3052 Target Database in Quiet Point
3053 Target Database is in a BI stall
3054 Target Database is in an AI stall
3055 Online backup of Target Database
3199 inactive
3255 unknown
$ DSRUTIL [source] -C
"STATUS:" 1100 "STATE CONNECTING"
"DETAIL:" 6002 "Connecting to Agents"
"AGENT:" 1001 "Initial connection"
$ DSRUTIL [target] -C
"STATUS:" 3104 "STATE LISTENING"
"DETAIL:" 2083 "Listening"
"AGENT:" 2083 "Listening"
Then when connected:
$ DSRUTIL [source] -C
"STATUS:" 1101 "STATE PROCESSING"
"DETAIL:" 6021 "Normal Processing"
"AGENT:" 3049 "Normal Processing"
$ DSRUTIL [target] -C
"STATUS:" 3101 "STATE PROCESSING"
"DETAIL:" 3049 "Normal Processing"
"AGENT:" 3049 "Normal Processing"
