Troubleshooting guide

You see:
Type Connection
---- ----------
PDS succeeded
(1 row affected)
b) If the result indicates a failure:
• The server is not responding, or
• One of the connection properties is incorrect.
Manually log in to the primary DB2 UDB database as the configured user to find which
property is incorrectly defined.
See "Testing network connectivity" in the
Replication Agent Administration Guide .
See also
• Initializing the Replication Agent Instance on page 100
Creating a Replication Server Connection to the Primary Database
Create a Replication Server connection to the primary database.
1.
In Replication Server, create a connection to the primary DB2 UDB database:
create connection to pds.pdb
using profile rs_rs_to_udb_ra;standard
set username muser
set password mpwd
with log transfer on, dsi_suspended
go
where:
•
pds is the value of the rs_source_ds parameter specified in Replication Agent.
•
pdb is the value of rs_source_db specified in Replication Agent.
• muser is the maintenance user for the primary DB2 UDB database.
• mpwd is the maintenance user password.
For information about the maintenance user, see the Replication Agent Primary Database
Guide .
2.
Use admin show_connections, 'primary' to display the primary connection you created.
Initializing the Replication Agent Instance
Initialize the Replication Agent instance.
The ra_admin init command verifies that the primary DB2 UDB database is correctly
configured to provide archived logging and that the DB2 UDB user ID used by the Replication
Agent has the necessary permissions. The ra_admin init command also creates objects in the
primary database to support replication.
Note: If, in your resource file, you set initialize_instance to yes, skip step 1 and continue to
step 2.
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
100 Replication Server