Troubleshooting guide
set password mpwd
go
For SAP Secure User Store:
create connection to rds.rdb
using profile rs_udb_to_hanadb;ech
set username auser
set password apwd
set dsi_connector_sec_mech to "hdbuserstore"
go
where:
•
rds
is the replicate SAP HANA database. For a standard connection, this must match
the data server name in the interfaces file entry. See the
Adaptive Server Enterprise
Configuration Guide for UNIX > Set Up Communications Across the Network >
Contents of the interfaces File
and the
Adaptive Server Enterprise Configuration Guide
for Windows > Network Communications Using sql.ini
. For an SAP Secure User Store
connection, this must match what you used as the key to create a user store of encrypted
credentials with the hdbuserstore utility.
•
rdb
is placeholder: You must provide a value, but it is not used..
•
muser
is the maintenance user for the replicate SAP HANA database instance that you
created in a previous step.
•
mpwd
is the replicate SAP HANA database maintenance user password.
•
auser
and
apwd
are unused values supplied only to satisfy the syntax of the create
connection command.
Note: For an SAP Secure User Store connection, the same user who ran the hdbuserstore
utility must run the create connection command.
If you have trouble connecting to the replicate SAP HANA database instance using
ExpressConnect for HANA DB, see the
Replication Server Troubleshooting Guide >
Common Error Messages > Connector Error Messages
.
7.
Use admin show_connections, 'replicate' to display the replicate connection you created.
Configuring Replication Server for Replication from the Primary Database
Configure Replication Server for replication from the primary database.
Granting create object Permission to the rs_username User
Grant create object permission to the user ID specified by the Replication Agent rs_username
parameter.
The rs_username user,which is used for communication between Replication Agent and
Replication Server, must have create object permission before it can be used to create a
replication definition. You must grant this permission manually from Replication Server.
1.
Log in to Replication Server:
isql -Usa -Psa_pass -SSAMPLE_RS
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 91