IBM Informix Transactional Replication Settings

Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog

The information below explains how to configure the transactional replication settings for Informix  in the Enable Transactional Replication wizard or the Transactional Log Settings dialog available from the Transactional Setup > Manage option on the connection in the Metadata Explorer.

When replicating from Informix using mirroring or synchronization, two transactional modes are available: Log Server Agent and Triggers.

Log Server Agent Settings

Triggers Settings

Additional Step for Synchronization Replications

For synchronization replications only, you also need to obtain the user ID number for the user specified in the source connection. This number will be used to edit the _config.ini file for the Windows service that reads the Informix log. To obtain and use the user ID number:

  1. Create the Windows service using the Install button as described above.

  2. From the command line, run the program InformixGetUserIDNumber.exe in the Syniti DR Install directory:
     InformixGetUserID.exe <informix-server-name> <userid> <password>
    where:
    <informix-server-name> is name of the informix server as defined in the source
    <userid> the name of the user defined in the source connection
    <password> the password for the user ID
    The application outputs a number which must be manually inserted into the _config.ini file in the folder for the Windows service.

  3. In the Windows Explorer, from the Syniti DR install directory, go to the Windows service folder.

  4. Edit the _config.ini file and locate the field USER_ID_NUMBER.

  5. Set the value to the number returned from your call to InformixGetUserIDNumber above.

  6. Save the file.

  7. Start the Windows service.