Troubleshooting guide

DSI Suspended 103 pds.pdb
24 DIST Awaiting Wakeup 103 pds.pdb
25 SQT Awaiting Wakeup 103:1 DIST pds.pdb
23 SQM Awaiting Message 103:1 pds.pdb
22 SQM Awaiting Message 103:0 pds.pdb
62 REP AGENT Awaiting Command pds.pdb
Testing Replication
When you finish setting up the replication system, test that replication works as intended.
1.
Connect to the primary DB2 UDB instance as a regular user, rather than as the
maintenance user. Make sure the regular user also exists in the replicate database.
a) To connect to the database with CLP, use:
CONNECT TO dbalias USER db2_user USING db2_user_ps
where dbalias is the cataloged alias of the primary database, db2_user is the primary
database user, and db2_user_ps is the password.
2.
At the primary DB2 UDB database, create a table named PTAB1 to replicate:
CREATE TABLE PTAB1
(IDNO INTEGER NOT NULL,
NAME VARCHAR(20),
PRIMARY KEY(IDNO))
3.
Grant permissions to any new or existing object to be replicated in the primary database:
grant all on PTAB1 to public
4.
Connect to Replication Agent through isql, and mark the PTAB1 table for replication:
pdb_setreptable PTAB1, mark
go
5.
In Replication Agent, create a replication definition against the primary DB2 UDB
database:
1> rs_create_repdef ptab1
2> go
Table/Procedure Name RepDef Name Status
--------------------- -------------- --------
<DB2TableOwner>.PTAB1 "<repdefname>" Created
(1 row affected)
Record the name of the replication definition for use later.
6.
At the replicate SAP HANA database instance, create a table named PTAB1:
CREATE TABLE <tableowner>.PTAB1
(IDNO INT PRIMARY KEY,
NAME VARCHAR(20));
case sensitive
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
102 Replication Server