Configuring UDB connectivity

On a Windows system, you must configure an ODBC data source in the UDB 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. Set the Replication Agent pds_datasource_name parameter to the database alias.

1. Log in as the UDB instance owner.

   Logging in sets up your UDB environment variables by executing the environment scripts. You can also execute these scripts manually as follows.

   In Korn shell, source the db2profile file:

   . $HOME/sqllib/db2profile
   

   In C shell, source the db2cshrc file:

   source $HOME/sqllib/db2cshrc
   

   Here, $HOME is the home directory of the UDB instance owner.

2. Start the UDB command-line processor by typing the db2 command.

3. Catalog the remote TCP/IP node using the following command at the UDB prompt:

   catalog tcpip node MYNODE remote MYHOST server XXXX
   

   Here, MYNODE is the node name, MYHOST is the host name or IP address of the data server, and XXXX is the data server port number.

4. Verify the catalog entry:

   list node directory
   

   UDB should return something similar to the following:

   Node 1 entry:
         Node name            = MYNODE
         Comment              = 
         Directory entry type = LOCAL
         Protocol             = TCPIP
         Hostname             = MYHOST
         Service name         = XXXX
   

1. Catalog the primary database using the following command at the UDB prompt:

   catalog database MYDB as MYDB_ALIAS at node MYNODE
   

   Here, MYDB is the database name, MYDB_ALIAS is an alias for the database, and MYNODE is the node name used in the catalog tcpip node command.

2. Verify the catalog entry:

   list database directory
   

   UDB should return something similar to the following:

   System Database Directory
   
   Number of entries in the directory = 1
   
   Database 1 entry:
   
   Database alias         = MYDB_ALIAS
   Database name          = MYDB
   Node name              = MYNODE
   Database release level = b.00
   Comment                = 
   Directory entry type   = Remote
   

1. In Replication Agent, set the pds_datasource_name parameter to the database alias:

   ra_config pds_datasource_name, MYDB_ALIAS
   

   Here, MYDB_ALIAS is the database alias that was used when cataloging the primary database.

2. Also set the following Replication Agent parameters:

   • pds_database_name

   • pds_username

   • pds_password

   See the Replication Agent Reference Manual.