Troubleshooting guide

For information on using the create subscription command in direct load materialization,
see Replication Server Reference Manual .
10.
On the Adaptive Server database, insert data into the primary ptab1 table:
insert into ptab1
values (3, "Tom Servo")
go
11.
On the SAP HANA database, verify that the data replicated to the replicate PTAB1 table:
SELECT * FROM PTAB1;
Resetting the Primary ASE Database For Replication
In a test environment, you may occasionally need to reset the replication environment.
1.
Log in to Replication Server:
isql –Usa –Psa_pass –SSAMPLE_RS
If you have not set up the sample Replication Server instance, enter your Replication
Server instance name in place of SAMPLE_RS.
2.
Connect to the primary database:
1>connect to pds.pdb
2>go
where:
• pds . pdb is the name of the primary connection.
• pds is the name of the Adaptive Server data server of the primary connection.
• pdb is the name of the Adaptive Server database of the primary connection.
3.
Stop the Replication Agent instance:
1>sp_stop_rep_agent pdb
2>go
4.
Set the database to release the secondary truncation point:
1>dbcc settrunc ('ltm','ignore')
2>go
5.
Disconnect from the primary database:
1>disconnect
2>go
6.
Connect to the RSSD:
1>connect to rssd
2>go
7.
Reset the locator stored in Replication Server:
isql -Usa -Psa_pass -SSAMPLE_RS
connect
go
rs_zeroltm pds, pdb
go
CHAPTER 3: ASE-to-SAP HANA Database Replication Setup
20 Replication Server