Troubleshooting guide

Parameter Description Value
rs.rs_db_maint_user User ID whose work is not re-
plicated when logged on the
primary database. The user is
called maintenance user.
<
database
>_maint
Note: If the user ID does not
exist, the script creates the user
ID on the database. The user
ID cannot be the name of an
alias.
rs.rs_db_maint_password Password for the maintenance
user.
<
database
>_maint_ps
rs.rs_ltm_rs_user User that the Replication
Agent will use to log into the
Replication Server. The name
must exist. This name typical-
ly comes from values that were
set up during Replication
Server creation time:
rs.rs_ltm_rs_user.
SAMPLE_RS_ra
rs.rs_ltm_rs_pass Password of the
rs.rs_ltm_rs_user.
sa_pass
rs.rs_db_physical_for_logi-
cal
Specifies whether this is a
warm standby database.
no
5.
Save the file.
6.
Go to $SYBASE/$SYBASE_REP/install.
7.
Create the connection from the primary database to the Replication Server by running the
resource file:
./rs_init -r ../init/rs/myprimary.rs
If the rs_init command fails, check the log file in $SYBASE/$SYBASE_REP/init/
logs, correct the issue, then disable the RepAgent as follows:
a.
Log in to the primary Adaptive Server using an “sa” user role and access the primary
database.
b.
Disable the RepAgent thread in the primary database:
sp_config_rep_agent pubs2,'disable'
go
Re-run rs_init command
8.
Validate the primary connection:
isql -Usa -Psa_pass -SSAMPLE_RS
9.
Enter:
admin who
go
CHAPTER 3: ASE-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 17