Troubleshooting guide

Note: Each SAP HANA database installs with a unique instance number, and the port
number is the instance number prefixed with 3 and suffixed with 15:
3in15
where in is the two-digit instance number. For example, the port number for an SAP
HANA database with instance number 1 is 30115.
If you are using SAP Secure User Store, create a user store of encrypted credentials:
hdbuserstore set rds myhost:xxxxx my_securestore_user
my_securestore_pwd
where
• rds is the key for the secure store entry
• myhost : xxxxx is the connection environment host name and port number
• my_securestore_user and my_securestore_pwd are SAP Secure User Store credentials
2.
On SAP HANA database, create a maintenance user:
a) As the SAP HANA database admin user, create a user ID with a temporary password:
CREATE USER muser PASSWORD mpwd_temp
b) Log in to SAP HANA database with the temporary password, and then update the
password:
ALTER USER muser PASSWORD mpwd_new
c) Log out of SAP HANA database, and log in again with the new password.
3.
Log in to SAP HANA database:
./hdbsql -u user -p password -i id
where user is the SAP HANA database user, password is the user password, and id is the
instance number.
4.
On SAP HANA database, grant these authorities to the maintenance user:
GRANT CREATE ANY, DELETE, DROP, EXECUTE,
INDEX, SELECT, UPDATE ON SCHEMA myschema TO muser
where
myschema is your SAP HANA database schema, and muser is the maintenance user
you just created.
5.
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.
6.
Create a connection to the replicate SAP HANA database instance using ExpressConnect
for HANA DB.
For a standard connection:
create connection to rds.rdb
using profile rs_udb_to_hanadb;ech
set username muser
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
90 Replication Server