isql –Usa –Psa_pass –SSAMPLE_RS
admin who
go
Note: Be aware that:
The DSI connection for the primary database connection is usually suspended
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 returns thread status similar to:
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) DCService.rdb
53 DSI Awaiting Message 102 DCService.rdb
17 SQM Awaiting Message 102:0 DCService.rdb
DSI EXEC Suspended 103(1) pds.pdb
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