Replication Agent for UDB requires the following to connect to a primary IBM DB2 Universal Database data server:
If the Replication Agent for UDB is installed on a different host machine from the IBM DB2 Universal Database server, you must install the IBM DB2 Universal Database Administration Client on the Replication Agent host machine.
If the Replication Agent for UDB software is installed on the same host machine as the IBM DB2 Universal Database server, a separate BM DB2 Universal Database Administration Client is not required.
On a Windows system, you may configure an ODBC data source in the IBM DB2 Universal Database Administration Client, then use the database name and database alias specified for that ODBC data source when you configure Replication Agent for UDB connectivity.
On a UNIX system, instead of using ODBC, simply catalog the node and the primary database in UDB. Then, use the database alias specified when cataloging the primary database to set the data source Replication agent configuration parameter.
If the Replication Agent for UDB is installed on a UNIX or Linux machine, you must source the UDB db2cshrc (for C-shell) or the db2profile (for Bourne and Korn shells) script before starting the Replication Agent. These scripts are located in one of the following paths:
$DB2DIR/cfg
Here, $DB2DIR is the path to the UDB client installation.
$HOME/sqllib
Here, $HOME is the home directory of the UDB instance owner (for UDB server installation.
For all Replication Agent platforms except HP Itanium, the library path environment variable must point to the location of the 32-bit UDB libraries, and not to the 64-bit libraries. The 32-bit versions of the libraries are located in the <library_path>/sqllib/lib32 directory. The exact name of the library path environment variable depends on the operating system.
Table 4-3 contains a description of the Replication Agent for DB2 UDB configuration parameters that must be set.
Configuration parameters |
Description |
---|---|
pds_username |
The IBM DB2 Universal Database user ID that the Replication Agent uses to log in to the primary database. This user ID must be granted permissions as described in “DB2 Universal Database primary database permissions”. |
pds_password |
The password for the IBM DB2 Universal Database user ID. |
pds_host_name |
The host name of the machine where the primary IBM DB2 Universal Database data server resides. |
pds_port_number |
The client socket port number where the IBM DB2 Universal Database data server listens for connections. |
pds_database_name |
The name of the primary database on the IBM DB2 Universal Database data server from which transactions will be replicated. |
pds_datasource_name |
The data source name or the primary database alias for the primary database in the IBM DB2 Universal Database data server. |