Troubleshooting guide

Note: SAP HANA database is not case-sensitive and uses uppercase characters if
lowercase characters are provided.
If an owner is not specified with the tablename, the owner of the table— <tableowner> —is
the user that is signed on at the time the table is created.
7.
Grant permissions to any new or existing object to be replicated in the replicate database so
that the Replication Server maintenance user can update this table:
grant all privileges on <tableowner>.PTAB1 to public
8.
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.
9.
Alter the replication definition that you created earlier to point to the correct replicate
table:
alter replication definition <repdefname>
with replicate table named <tableowner>.ptab1
go
10.
Create a subscription against the replicate connection.
To create the ptab1_sub subscription for the
<repdefname> replication definition:
create subscription ptab1_sub
for <repdefname>
with replicate at rds.rdb
without materialization
go
where
<repdefname> is the replication definition that you altered in the previous step, and
rds . rdb is the name of the replicate SAP HANA database connection created earlier.
For information on using the create subscription command in direct load materialization,
see Replication Server Reference Manual .
11.
On the DB2 UDB database, insert data into the primary PTAB1 table and commit:
INSERT INTO PTAB1
(IDNO, NAME) VALUES
(6, 'Dr. Forrester');
COMMIT;
12.
On the SAP HANA database, verify that the data replicated to the replicate PTAB1 table:
SELECT * FROM <tableowner>.PTAB1;
Resetting the Primary DB2 UDB Database for Replication
In a test environment, you may occasionally need to reset the replication environment.
1.
Log in to the Replication Agent and issue:
suspend
go
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 103