Initialize the Replication Agent instance.
ra_admin init go
resume go
State Action ----------------- -------------------------- REPLICATING Ready to replicate data.
isql –Usa –Psa_pass –Smyra 1> resume 2> go Msg 32000, Level 20, State 0: Server 'myra', Procedure 'resume', Line 1: Command <resume> failed - Desired state <REPLICATE> could not be achieved. Current state: <REPLICATION DOWN>
ra_status go
State Action ----------------- ------------------------- REPLICATING Ready to replicate data.
1> ra_status 2> go State Action ----------------- ----------------------- REPLICATION DOWN Waiting for operator command.
isql -Usa -Psa_pass -SSAMPLE_RS admin who go
isql -Uusername -Ppassword -SSAMPLE_RS admin who go
Do not proceed until admin who returns status for threads similar to this:
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 54 DSI EXEC Awaiting Command 102(1) rds.rdb 53 DSI Awaiting Message 102 rds.rdb 17 SQM Awaiting Message 102:0 rds.rdb 20 DSI EXEC Suspended 103(1) pds.pdb 21 DSI Suspended 103 pds.pdb 24 DIST Awaiting Wakeup 103 pds.pdb 25 SQT Awaiting Wakeup 103:1 DIST pds.pdb 23 SQM Awaiting Message 103:1 pds.pdb 22 SQM Awaiting Message 103:0 pds.pdb 62 REP AGENT Awaiting Command pds.pdb