Section 5: Replication Agent parameter values for the primary data server

Determine and record the values of the Replication Agent configuration parameters for the primary data server.

To complete Section 5 of the Installation and Setup worksheet

If your primary database type is Informix, Microsoft SQL Server, or Oracle, identify the name of the primary data server host machine.

Record the host machine name as item 5a (pds_host_name) on the “Installation and Setup worksheet”.

If your primary database type is Informix, Microsoft SQL Server, or Oracle, identify the port number of the client socket port for the primary data server.

Port numbers have a range of 1 to 65,535.

Record the client socket port number as item 5b (pds_port_number) on the “Installation and Setup worksheet”.

If the primary database type is DB2 Universal Database, you do not need to specify values for the pds_host_name and pds_port_number parameters.

If your primary database type is Informix or Microsoft SQL Server, identify the name of the primary database server.

Record the primary database server name as item 5c (pds_server_name) on the “Installation and Setup worksheet”.

Identify the name of the primary database on the primary data server.

The value of the pds_database_name parameter (worksheet item 5d) can be identical to the value of rs_source_db (worksheet item 2b), as long as the value of the pds_database_name parameter exists as a valid database at the primary database server.

If your primary database server is Oracle, you must use the value of the ORACLE_SID system environment variable (%ORACLE_SID% on Windows 2000 and 2003, or $ORACLE_SID on UNIX).

Record the database name as item 5d (pds_database_name) on the “Installation and Setup worksheet”.

If your primary database server is DB2 Universal Database, identify the data source name (DSN) configured in the ODBC driver for the primary database. The value of the data source name parameter (pds_datasource_name) must be the DB2 database alias that identifies the primary database.

Record the appropriate value for the data source name (DSN) as item 5e (pds_datasource_name) on the “Installation and Setup worksheet”.

Identify the user ID and password that Replication Agent uses to log in to the primary data server.

This user ID must not be the same as the Replication Server maintenance ID for the primary database connection.

This primary data server user ID must have several database-level privileges for the primary database. See the Sybase Replication Agent Primary Database Guide for more information.

Record this primary data server user ID as item 5f (pds_username) and the password as item 5g (pds_password on the “Installation and Setup worksheet”.

Identify the character set of the primary database.

For a list of valid Java character sets for your primary database, see Supported Encodings on the Internationalization page under Documentation for the J2SE 1.4.2 JDK .

Record the name of the equivalent Java character set as item 5h on the “Installation and Setup worksheet”.