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

Item

Description

Example value

Your value

5a

pds_tns_filename

NoteThis value is for Oracle only.

The fully-qualified file name identifying the Oracle tnsnames.ora file that contains connection properties for the primary Oracle data server.

/path1/tnsnames.ora

5b

pds_tns_connection

NoteThis value is for Oracle only.

The Oracle connection name that identifies the primary database connection in the Oracle tnsnames.ora file

SALES_DB_CONN

5c

asm_tns_filename

NoteThis value is for Oracle only.

Identifies the Oracle tnsnames.ora filename where the ASM connection information is located. If this is the same tnsnames.ora file as configured in pds_tns_filename, you can leave this parameter unset.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

/path2/tnsnames.ora

5d

asm_tns_connection

NoteThis value is for Oracle only.

Identifies the Oracle ASM connection name found in the tnsnames.ora file.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

+ASM1_CONN

5e

asm_username

NoteThis value is for Oracle only.

Identifies the Oracle user name to be used when connecting to the ASM server.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

sys as sysdba

5f

asm_password

NoteThis value is for Oracle only.

Password for Oracle ASM access for the user specified in asm_username.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

change_on_install

5g

pds_port_number

NoteThis value is for Microsoft SQL Server only.

This is the client socket port number for the primary database gateway server.

1111

5h

pds_server_name

NoteThis value is for Microsoft SQL Server only.

This is the name of the Microsoft SQL Server primary database server.

doc_23

5i

pds_database_name

This is the name of the primary database on the primary database server.

Replication Agent uses this value to determine which database is the primary database.

NoteFor Oracle, use the $ORACLE_SID. For Microsoft SQL Server and for UDB, use the actual name of the primary database.

sales_db

5j

pds_datasource_name

NoteThis value is for DB2 Universal Database only.

This is the data source name (DSN) of the ODBC driver or the catalogued database alias for the primary database.

sales_db_alias

5k

pds_username

This is the user ID that Replication Agent uses to log in to the primary database.

pds_user

5l

pds_password

This is the password for pds_username.

pds_pw

5m

This is the Java-equivalent of the primary database character set.

NoteUnless you want to override the default character set that the JVM finds on your system, you do not need to explicitly set the character set-related environment variable, RA_JAVA_DFLT_CHARSET. However, the system default character set must match the character set of the primary database.

  • On UNIX: ISO8859_1

  • On Windows: Cp850

5n

pds_dac_port_number

NoteThis value is for Microsoft SQL Server only.

The dedicated administration connection port number that Replication Agent uses to connect to the primary database during the server-level initialization of the primary data server.

1348