Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe describes the concepts of data replication using Informix® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Preparing the Replication EnvironmentThe following topics explain the steps that are required for setting up Enterprise Replication.
Preparing the Database Server EnvironmentTo prepare the database server environment, set database server environment variables and configuration parameters, and synchronize the operating system time on all participating database servers.
Setting Database Server Environment VariablesCertain environment variables must be set in a replication environment.

Setting Database Server Environment Variables

Certain environment variables must be set in a replication environment.

About this task

To configure the database server environment, verify that the following environment variables are set correctly:

INFORMIXDIR is set to the full path of the Informix® directory.
INFORMIXSERVER is set to the name of the default database server.
INFORMIXSQLHOSTS is set to the full path to the SQLHOSTS file.
DELIMIDENT is not set or set to n. Enterprise Replication does not allow delimited identifiers.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.