Updating the Interfaces Files

Use a text editor to modify all the interfaces file for the souce database, Replication Server and Sybase IQ InfoPrimer.

1. Navigate to the interfaces file.

   • On Windows, the file is <installation_directory>\ini\sql.ini.

   • On UNIX and Linux, the file is <installation_directory>/interfaces

2. Modify all three interfaces files to include:
   • Entries for Replication CDC Services of all Sybase IQ InfoPrimer Servers.

     • On Windows for example, use:

       [<cdc_service_name>]
       master=TCP,<machine_name>,<port>
       query=TCP,<machine_name>,<port>

     • On UNIX or Linux, use:

       <cdc_service_name>
       master tcp sun-ether <machine_name> <port>
       query tcp sun-ether <machine_name> <port>

     where:

     <cdc_service_name> is a unique Replication CDC Service name to be used by a single Sybase IQ InfoPrimer Server.

     <machine_name> is the name of the machine on which the grid Sybase IQ InfoPrimer Server runs.

     <port> is the port on which the Replication CDC Service listens.

   • A SYBETL_VIR_RDBMS entry that contains all CDC Service entries.

     • On Windows for example, use:

       [SYBETL_VIR_RDBMS]

       	master=TCP,<machine_name_1>,<port>

       query=TCP,<machine_name_1>,<port>

       master=TCP,<machine_name_2>,<port>

       query=TCP,<machine_name_2>,<port>

     • On UNIX and Linux, use:

       SYBETL_VIR_RDBMS

       master tcp sun-ether <machine_name_1> <port>

       query tcp sun-ether <machine_name_1> <port>

       master tcp sun-ether <machine_name_2> <port>

       query tcp sun-ether <machine_name_2> <port>

     Note:

     The IP port of the virtual database and Replication CDC Services should match.

   • If the source database is Adaptive Server Enterprise, create or copy the entries for your Adaptive Server Enterprise source database, Replication Server, and Embedded Replication Server System Database (ERSSD) or RSSD.

     If the source database is Oracle, create or copy the entries for your Replication Agent™, Replication Server, and Embedded Replication Server System Database (ERSSD) or RSSD.

     • On Windows for example, use:

       [<ase_name>]
       master=tcp,<ase_machine_name>,<ase_port>
       query=tcp,<ase_machine_name>,<ase_port>
       
       [<repserver_name>]
       master=tcp,<repserver_machine_name>,
              <repserver_port>
       query=tcp,<repserver_machine_name>,
              <repserver_port>
       [<erssd_name>]
       master=tcp,<erssd_machine_name>,<erssd_port>
       query=tcp,<erssd_machine_name>,<erssd_port>

     • On UNIX and Linux, use:

       <ase_name>
       master tcp sun-ether <ase_machine_name> <ase_port>
       query tcp sun-ether <ase_machine_name> <ase_port>
       
       <repserver_name>
       master tcp sun-ether <repserver_machine_name>
       <repserver_port>
       query tcp sun-ether <repserver_machine_name> <repserver_port>
       <erssd_name>
       master tcp sun-ether <erssd_machine_name> <erssd_port>
       query tcp sun-ether <erssd_machine_name> <erssd_port>