Informix Server and Client Setup

If you are planning to use Informix version 11.5 FC3 or above as your source database for mirroring or synchronization using a transaction log,  you need to perform additional installation steps on the Informix server.

  1. Check that you are using Informix IDS database version 11.5 FC3 or above

  2. Ask a Database Administrator (DBA) to execute the script syscdcv1.sql that comes with the database to create the database syscdcv. The tables are required by Syniti Data Replication.

  3. Make sure that The database containing the source data to be replicated was created with logging enabled.
    In the unlikely event that logging is not enabled, a DBA can use the ondblog utilty to change the logging mode (together with the onbar utility to backup the database after the logging mode is changed,)

  4. For the user ID that will be used to connect the database from Syniti DR, grant CONNECT and DBA privileges both to the source database and to the syscdcv1 database. For example:
    grant connect to "dbmotouser1"
    grant dba to "dbmotouser1"

  5. Make sure that the user ID is in the informix-admin group.

The following steps should be performed on the client machine where Syniti DR is installed and run.

  1. Install the latest Informix Client SDK (currently version 3.70) with the ESQL option and the .NET Data Provider.

  2. Use the SetNet32 utility to define the server.

  3. Verify the connection to the database using the ILogin.exe demo.

  4. Set up the permissions for the Windows user that runs Syniti DR to create and delete Windows services.

Related Topics
Informix Transaction Log Setup Info