Section 1: Replication Agent administration information

Determine and record the Replication Agent administration information and record it in Section 1 of the worksheet.

StepsCompleting Section 1 of the Installation and Setup worksheet

  1. Determine the instance type of the Replication Agent. This instance type indicates which primary database server the Replication Agent will work with.

    Instance types are:

    • mssql – Microsoft SQL Server (Replication Agent for Microsoft SQL Server must be installed on a Microsoft Windows host from which it can directly access the primary Microsoft SQL Server transaction logs.)

    • oracle – Oracle Database Server (Replication Agent for Oracle must be installed on a UNIX or Microsoft Windows host from which it can directly access the primary Oracle redo logs.)

    • ibmudb – IBM DB2 Universal Database (UDB) (Replication Agent for UDB must be installed on the same UNIX or Microsoft Windows host as the DB2 UDB server or a DB2 UDB client.)

    Record the instance type as item 1a in Section 1: Replication Agent administration information on the “Installation and Setup worksheet.”

  2. Determine the name of the Replication Agent instance. This name should identify this specific instance.

    Record the name of the instance as item 1b in Section 1: Replication Agent administration information on the “Installation and Setup worksheet.”

  3. Identify the client socket port number of the administration port for this Replication Agent instance. The port number must be unique on the Replication Agent host machine.

    If you are not the System Administrator for the system on which you are installing the Replication Agent instance, ask your System Administrator which port number you should use for the Replication Agent administration port.

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

    Record the port number as item 1c in Section 1: Replication Agent administration information on the “Installation and Setup worksheet.”

    NoteReplication Agent for Oracle and Replication Agent for Microsoft SQL Server each require two port numbers. The additional one is for the RASD. By default, Replication Agent assigns the RASD port—admin port +1. This number must also be unique on the Replication Agent host machine. For more information, see “Accommodating the RASD”.

  4. Determine the location of the interfaces file (sql.ini on Microsoft Windows or interfaces on Linux and UNIX).

    Use this item only if you plan to use the isql or jisql utility or Replication Manager (RM) to administer the Replication Agent instance.

    NoteThe interfaces file must reside on the same machine as the Replication Agent client (isql or Replication Manager) not necessarily on the Replication Agent host machine.

    Record the interfaces file location as item 1d in Section 1: Replication Agent administration information on the “Installation and Setup worksheet.”

  5. Determine the administrative user ID and password for logging in to the Replication Agent administration port. Use this information to create the administrative user ID during configuration and setup.

    For more information, see the Replication Agent Administration Guide.

    Record the administrative user ID as item 1e (admin_user) and the password as item 1f (admin_pw) in Section 1: Replication Agent administration information on the “Installation and Setup worksheet.”