A single installation of the Replication Agent can support replication from multiple databases. However, one Replication Agent instance is needed for each IBM DB2 Universal Database that is to be replicated.
To replicate from multiple databases, using one Replication
Agent instance for each database, you must create a separate IBM
DB2 Universal Database user for each primary database, as described
in “Creating an IBM DB2 Universal Database user and grant permissions”.
You cannot use the same user for multiple Replication Agents.
Preparing the Replication Agent instance
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 Replication Agent instance, allowing an instance to be removed and re-created.
The resource file template for an IBM DB2 Universal Database instance is $SYBASE/RAX-15_2/init/ibmudb.rs (UNIX or Linux) or %SYBASE%\RAX-15_2\init\ibmudb.rs (Windows).
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 IBM DB2 Universal Database, 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.
The resource file is self-documenting, with each parameter described. See the Replication Agent Administration Guide.
Table 3-4 lists
parameters in the order they appear in the resource file, not alphabetically.
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) |
pds_host_name |
Machine (host) where IBM DB2 Universal Database is installed. |
NY |
pds_port_number |
Port number for IBM DB2 Universal Database. |
50007 |
pds_database_name |
Name of the primary database. |
NYudb9 |
pds_username |
User ID that Replication Agent uses to access primary data server. |
ra_user |
pds_password |
Password for pds_username. |
sybase |
pds_datasource_name |
Data source name or database alias for the primary database |
DBALIAS |
rs_host_name |
Machine where Replication Server is installed. |
jdoe_host1 |
rs_port_number |
Port where Replication Server is installed. |
11752 |
rs_username |
Replication Server user with CONNECT SOURCE and CREATE OBJECT capabilities. |
SAMPLE_RS_ra |
rs_password |
Password for rs_username. |
SAMPLE_RS_ra_ps |
rs_source_ds |
Valid name representing data server of primary IBM DB2 Universal Database. |
NY |
rs_source_db |
Valid name representing primary IBM DB2 Universal Database. |
NYudb9 |
rs_charset |
Character set that Replication Server is using.
|
|
rssd_host_name |
Machine where RSSD resides. |
jdoe_host1 |
rssd_port_number |
Port number where RSSD resides. |
11751 |
rssd_database_name |
Database name for RSSD. |
SAMPLE_RS_ERSSD |
rssd_username |
Valid user for RSSD. |
SAMPLE_RS_RSSD_maint |
rssd_password |
Password for rssd_username. |
SAMPLE_RS_RSSD_maint_ps |
pdb_archive_remove |
Enables or disables the removal of archived IBM DB2 Universal Database transaction log files from the path specified by pdb_archive_path. |
USE_DEFAULT |
pdb_archive_path |
Identifies directory path where Replication Agent expects to find archived IBM DB2 Universal Database transaction log files. |
A valid directory path on the machine hosting Replication Agent that points to a location where IBM DB2 Universal Database puts the archived transaction log files |
start_instance |
Start the instance that was created. |
yes |
initialize_instance |
Initialize the Replication Agent instance. |
yes |
WARNING! The rs_source_ds and the rs_source_db values must match the “pds.pdb” values of your Replication Server primary connection name that you configured in step 3 in the procedure “Creating a Replication Server connection to the primary database”.
Set the IBM DB2 Universal Database environment variables by sourcing db2cshrc, db2profile, or your customized versions of the scripts as described in “Setting IBM DB2 Universal Database environment variables”.
Create and execute the new instance resource file:
Validate the settings in the resource file using the -vr parameter.
On UNIX or Linux:
$SYBASE/RAX-15_2/bin/ra_admin.sh -vr myra.rs
On Windows:
%SYBASE%\RAX-15_2\bin\ra_admin.bat -vr myra.rs
Here, myra.rs is the path and name of the resource file.
Validation results are returned as one of the following:
Response-file processing completed
Response-file processing completed
with errors
If any validation fails, the ra_admin utility returns an error message and information about the failure. You can repeat the validation process as many times as necessary until it executes without error. No entities are changed or created.
After the resource file has been validated, allow the ra_admin utility to create and configure the Replication Agent instance, using the -r parameter.
On UNIX or Linux:
$SYBASE/RAX-15_2/bin/ra_admin.sh -r myra.rs
On Windows:
%SYBASE%\RAX-15_2\bin\ra_admin.bat -r myra.rs
Here, myra.rs is the path and name of the resource file.
If, in your response file, you set start_instance to yes,
your instance is also running. If you set initialize_instance to yes,
your instance is also initialized.
Creation results are returned as one of the following:
Response-file processing completed
Response-file processing completed
with errors
See the Replication Agent Administration Guide.
If, in your resource file, you set start_instance to yes, skip this step, and continue with the next section. If your resource file did not configure start_instance to yes, change to the instance directory and run Replication Agent in the background.
On UNIX or Linux:
cd $SYBASE/RAX-15_2/myra
On Windows:
cd %SYBASE%\RAX-15_2\myra
Execute the RUN file in the background.
Your Replication Agent for UDB is now running.
