Troubleshooting guide

1.
Locate the resource file template.
The majority of configuration values required to create and initialize a Replication Agent
can be recorded and stored in a resource file. Using a resource file provides a way to record
or retain the configuration information for a Replication Agent instance, allowing an
instance to be removed and re-created.
The resource file template for a DB2 UDB instance is $SYBASE/RAX-15_5/init/
ibmudb.rs (UNIX or Linux) or %SYBASE%\RAX-15_5\init\ibmudb.rs
(Windows).
2.
Create an instance resource file:
• Copy the resource file template to another file that contains the configuration
information for a new instance, for example, myra.rs.
• Change the values assigned to properties in the resource file so they match the values
required for your environment. The majority of these values are host, port, user, and
password information for the DB2 UDB, Replication Server, and RSSD connections.
• Set the value of
rs_source_ds
to the value you chose for pds in previous
procedures.
• Set the value of
rs_source_db
to the value you chose for pdb in previous
procedures.
• When you create a Replication Agent instance with a resource file:
• The asa_password configuration parameter value must not contain single quotes,
double quotes, or a semicolon.
• The pds_username and pds_password configuration parameter values must not
contain single or double quotes if the create_pds_username parameter is set to
yes.
The resource file is self-documenting, with each parameter described. See the Replication
Agent Administration Guide .
Note: This table lists parameters in the order they appear in the resource file, not
alphabetically.
Table 4. Resource File Parameters
Parameter Description Example values
instance name Any valid name. myra
admin_port Port number that Replication Agent uses. 9030 (if in use, select a different
port number)
ltm_admin_user User name for administering the Replication
Agent instance.
sa
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 95