Creating the Replication Agent Instance

Prepare and create a Replication Agent instance for replication of each DB2 UDB database.

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).
   The resource file template for a DB2 UDB instance is $SYBASE/RAX-15_2/init/ibmudb.rs (UNIX or Linux) or %SYBASE%\RAX-15_2\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.

   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
   ltm_admin_pw	Password for the user administering the Replication Agent instance.	The default password policy is that the password must be between 6 and 255 characters. For example: sa_pass
   pds_host_name	Machine (host) where DB2 UDB is installed.	NY
   pds_port_number	Port number for DB2 UDB. Note: Make sure you know which port your DB2 UDB instance is using. You can find this information in the /etc/services file.	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 number where Replication Server is installed.	11752
   rs_username	Replication Server user with connect source and create object permissions.	SAMPLE_RS_ra
   rs_password	Password for rs_username.	SAMPLE_RS_ra_ps
   rs_source_ds	Valid name representing data server of the primary DB2 UDB database.	NY
   rs_source_db	Valid name representing the primary DB2 UDB database.	NYudb9
   rs_charset	Character set that Replication Server is using. Note: The value defined for the rs_charset configuration parameter must match the RS_charset value in the Replication Server configuration file, $SYBASE/REP-15_5 /install/<server>.cfg (UNIX or Linux) or %SYBASE%\REP-15_5 \install\<server>.cfg (Windows).	Windows: cp850 UNIX: iso_1
   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 DB2 UDB 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 DB2 UDB transaction log files.	A valid directory path on the machine hosting Replication Agent that points to a location where DB2 UDB 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.
3. Set the DB2 UDB environment variables by sourcing db2cshrc, db2profile, or your customized versions of the scripts as described in Setting DB2 UDB Environment Variables.
4. Create and execute the new instance resource file:
   1. Validate the settings in the resource file using the -vr parameter.

      • On Windows:

        %SYBASE%\RAX-15_5\bin\ra_admin.bat -vr myra.rs

        %SYBASE%\RAX-15_2\bin\ra_admin.bat -vr myra.rs

      • On UNIX or Linux:

        $SYBASE/RAX-15_5/bin/ra_admin.sh -vr myra.rs 

        $SYBASE/RAX-15_2/bin/ra_admin.sh -vr myra.rs 

      where myra.rs is the path and name of the resource file.

      Validation results are returned as either:

      • Response-file processing completed, or,

      • 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.

   2. 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 Windows:

        %SYBASE%\RAX-15_5\bin\ra_admin.bat -r myra.rs

        %SYBASE%\RAX-15_2\bin\ra_admin.bat -r myra.rs

      • On UNIX or Linux:

        $SYBASE/RAX-15_5/bin/ra_admin.sh -r myra.rs 

        $SYBASE/RAX-15_2/bin/ra_admin.sh -r myra.rs 

      where myra.rs is the path and name of the resource file.

      Note: 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.
   3. Creation results are returned as either:

      • Response-file processing completed

        Or

      • Response-file processing completed with errors

      See the Replication Agent Administration Guide.

5. 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 false, change to the instance directory and run Replication Agent in the background.

   • On Windows:

      cd %SYBASE%\RAX-15_5\myra

   • On UNIX or Linux:

      cd $SYBASE/RAX-15_5/myra

   Execute the RUN_myra file in the background.