Troubleshooting guide

The output from the command looks similar to:
Spid Name State Info
---- ----- ------ --------
32 DSI EXEC Awaiting Command 101(1)
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
18 DSI Awaiting Message 101 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
23 DIST Awaiting Wakeup 101 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
29 SQT Awaiting Wakeup 101:1 DIST
SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
11 SQM Awaiting Message 101:1 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
9 SQM Awaiting Message 101:0 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
36 REP AGENT Awaiting Command SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
156 DSI EXEC Awaiting Command 267(1) sunak1502i.pubs2
140 DSI Awaiting Message 267 sunak1502i.pubs2
136 DIST Awaiting Wakeup 267 sunak1502i.pubs2
134 SQT Awaiting Wakeup 267:1 DIST sunak1502i.pubs2
142 SQM Awaiting Message 267:1 sunak1502i.pubs2
155 SQM Awaiting Message 267:0 sunak1502i.pubs2
135 REP AGENT Awaiting Command sunak1502i.pubs2
162 DSI EXEC Awaiting Command 268(1) rds.rdb
157 DSI Awaiting Message 268 rds.rdb
133 SQM Awaiting Message 268:0 rds.rdb
21 dSUB Sleeping
6 dCM Awaiting Message
7 dAIO Awaiting Message
26 dREC Sleeping dREC
8 dDELSEG Awaiting Message
163 USER Active sa
5 dALARM Awaiting Wakeup
27 dSYSAM Sleeping
10.
Exit the isql session.
Testing Replication
When you finish setting up the replication system, test that replication works as intended.
1.
Connect to the primary Adaptive Server instance as a non-maintenance user with the
ability to create tables.
2.
At the primary Adaptive Server database, create a table named ptab1 to replicate:
create table ptab1
(idno int not null,
name varchar(20) null)
go
sp_primarykey ptab1, idno
go
CHAPTER 3: ASE-to-SAP HANA Database Replication Setup
18 Replication Server