Troubleshooting guide
# force 32-bit libraries
LD_LIBRARY_PATH=$HOME/sqllib/lib32:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
4.
Before starting Replication Agent, always source your file, if you have customized it.
Otherwise, source the original db2cshrc or db2profile script.
Node and Database Cataloging in an DB2 UDB Client
If Replication Agent for DB2 UDB is installed on a different host than the primary database, it
must use DB2 UDB client libraries.
If you have installed Replication Agent for DB2 UDB on a different host than the primary
database, see the
Replication Agent Primary Database Guide
for information on node and
database cataloging in a DB2 UDB client.
Configuring Replication Server
Review the procedures for configuring Replication Server for DB2 UDB-to-SAP HANA
database replication.
Obtaining the SAP HANA Database ODBC Drivers
Set up ExpressConnect for HANA DB for connections between SAP HANA database and
Replication Server.
You must add the SAP HANA database ODBC driver to the ExpressConnect for HANA DB
installation. Download these libraries from the SAP Service Marketplace and install them
after you have installed Replication Server. See the
Replication Server Release Bulletin >
Special Installation Instructions > Installing ODBC Libraries for ExpressConnect for HANA
DB
.
Configuring Replication Server for Replication to SAP HANA Database
Create a Replication Server connection to SAP HANA database.
If you are not using the sample Replication Server instance, see the
Replication Server
Configuration Guide
for instructions.
1.
If you are connecting to SAP HANA database with a standard connection and not using
SAP Secure User Store, add an entry to your Replication Server interfaces file identifying
the replicate SAP HANA database, and then stop and start Replication Server:
[dataservername]
master tcp ether hostname port
query tcp ether hostname port
where
hostname
and
port
are the host and port number of the SAP HANA database, and
dataservername
is a label used to identify the host and port number. For information about
stopping and starting Replication Server, see the
Replication Server Administration Guide
Volume 1 > Manage a Replication System
.
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 89