Verifying the Replication Agent replicating state
Enter:
resume
go
If the Replication Agent successfully transfers to a replicating state, the following result is returned:
State Action
-------------------------------------
REPLICATING Ready to replicate data.
A returned state of Admin indicates that an error prevented the replicating state from being achieved. To determine the error, review the contents of the Replication Agent system log.
The ra_status command returns the state of the Replication Agent. It is good practice to verify that the Replication Agent remains in replicating state, even after the resume command executes successfully.
To detect an error that occurred after replication start-up, execute:
ra_status
go
If the Replication Agent is in replicating state, ra_status returns:
State Action
------------ -------------------------
REPLICATING Ready to replicate data.
A returned state of Admin indicates that an error prevented the replicating state from being achieved. To determine the error, review the contents of the Replication Agent system log.
Validate that both primary and replicate connections are active:
isql -Usa -P -SSAMPLE_RS
admin who
go
Be aware that:
The DSI connection for the primary database connection is usually down because you are not replicating data back to the primary database.
The Replication Agent connection, if established for the replicate database connection, is usually down, because you are not replicating data from the replicate database.
Do not proceed until admin who has similar status for threads to the following:
admin who
go
The following appears:
Spid Name State Info
---- ---------- ---------------
--------------------------------
13 DSI EXEC Awaiting Command 101(1)
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
9 DSI Awaiting Message 101
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
8 SQM Awaiting Message 101:0
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
8 SQM Awaiting Message 101:0
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
54 DSI EXEC Awaiting Command 102(1)
my_mssql_access_service.rdb
53 DSI Awaiting Message 102 my_mssql_access_service.rdb
17 SQM Awaiting Message 102:0 my_mssql_access_service.rdb DSI EXEC Suspended 103(1) NY.NYmss5
DSI Suspended 103 NY.NYmss5
24 DIST Awaiting Wakeup 103 NY.NYmss5
25 SQT Awaiting Wakeup 103:1 DIST NY.NYmss5
23 SQM Awaiting Message 103:1 NY.NYmss5
22 SQM Awaiting Message 103:0 NY.NYmss5
62 REP AGENT Awaiting Command NY.NYmss5
