Replication Agent for IBM DB2 Universal Database (UDB) must be installed on the same UNIX or Microsoft Windows host as the UDB server or the UDB Administration Client. Replication Agent requires access to UDB JDBC drivers and UDB API libraries.
The DB2 JDBC driver is effectively a JDBC/ODBC
bridge. For each primary database, you must configure an ODBC data
source name (DSN) in the DB2 client software.
If the Replication Agent is installed on the same host machine as the DB2 Universal Database primary data server, a separate DB2 client is not required for connectivity.
If the Replication Agent host machine is not the same as the DB2 Universal Database host, you must install the DB2 Administration Client on the Replication Agent host machine.
For information on installing the DB2 Administration Client on your Replication Agent host machine, see the IBM publication, DB2 Universal Database and DB2 Connect, Installation and Configuration Supplement.
Setting up connectivity to a DB2 UDB server
When you install a DB2 client on a UNIX platform, you need to source db2cshrc to correctly set all required DB2 environment variables. On Linux and Windows only, if your DB2 installation is 64 bit, you must customize the script to point to the 32-bit client libraries. See the Replication Agent Primary Database Guide for more information.
Add the following to the .login file of the user account that starts and stops the Replication Agent instance:
source /path_name/sqllib/db2cshrc
where path_name is the path where you installed the DB2 client. You must log out and log back in for this change to take effect, or issue the command source .login after the change.
When you install a DB2 client on Microsoft Windows,
the installation program modifies all required environment variables automatically.
For each primary database (regardless of platform), you must configure an ODBC data source name (DSN) in the DB2 client software. Make a note of the database name and datasource name when you configure the data source.
Be sure to record the database name and datasource name in the following Replication Agent configuration parameters:
pds_database_name – primary database name
pds_datasource_name – cataloged database alias or the ODBC data source name for the primary database
