IBM Informix Topics
Syniti Data Replication supports use of IBM Informix for:
- Refresh replications, both source and target
- Mirroring replications, both source and target. For source connections, Syniti Data Replication offers the Log Server Agent and triggers
- Synchronization
When setting up IBM Informix for use with the Log Server Agent:
-
Use Informix v 11.5 FC3 or above
-
Execute the script syscdcv1.sql on the server
-
Database should have logging enabled.
-
Consider the following option: in the Transactional Log Settings Extra Options field, set TURN_OFF_FULLROWLOGGING=NO. For more information, review this article in the Help Center.
-
Syniti DR user should have CONNECT and DBA privileges to source database and syscdcv1 database
-
Install and test the latest Informix Client SDK with the ESQL option and the .NET Data Provider
When setting up IBM Informix for use with the Syniti DR triggers:
-
Create or assign tables for Master Table and Log Table (DBMS tools)
-
Assign a tablespace for the Master table and Log Tables (DBMS tools)
This section contains topics that describe:
- Informix Server Client Setup
- Informix Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)
- Informix Transaction Log Information (in the in the Create Replication wizard and Create Multiple Replications wizard Source Log Info screen)
- Trigger Transactional Replication Settings
Further Resources
- For a complete up-to-date list of supported sources and targets, and information on where to obtain a .NET provider, check the Supported .NET Providers article in the Help Center.
- The Help Center also provides database-specific setup notes in PDF format.