Home
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise Replication
The HCL® Informix® Enterprise Replication Guide 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.
Planning and designing for Enterprise Replication
Before you set up your replication system, plan how to include Enterprise Replication into your database server environment, design your database schema by following Enterprise Replication requirements, and then design your replication system between database servers.
Plan for Enterprise Replication
Before you design a replication system, you must understand how Enterprise Replication interacts with the database server and the other requirements of Enterprise Replication. Many aspects of the Informix® database server can affect how you deploy Enterprise Replication.
Global language support for replication
You can replicate data in non-default locales.

Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
- System administration
  These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
- Backup and Restore Guide
  The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
- Enterprise Replication
  The HCL® Informix® Enterprise Replication Guide 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.
  - About Enterprise Replication
    Informix® Enterprise Replication generates and manages multiple copies of data at one or more sites, which allows an enterprise to share corporate data throughout its organization.
  - Planning and designing for Enterprise Replication
    Before you set up your replication system, plan how to include Enterprise Replication into your database server environment, design your database schema by following Enterprise Replication requirements, and then design your replication system between database servers.
    - Plan for Enterprise Replication
      Before you design a replication system, you must understand how Enterprise Replication interacts with the database server and the other requirements of Enterprise Replication. Many aspects of the Informix® database server can affect how you deploy Enterprise Replication.
      - Enterprise Replication Server administrator
        You need special privileges to run most Enterprise Replication commands.
      - Asynchronous propagation conflicts
        Enterprise Replication asynchronously propagates many control operations through the Enterprise Replication network. Avoid operations that might conflict during propagation.
      - Back up and restore of replication servers
        You can back up and restore database servers that participate in Enterprise Replication.
      - Compression of replicated data
        You can compress and uncompress data in replicated tables to reduce the amount of needed disk space.
      - Transaction processing impact
        Many variables affect the impact that replicating data has on your transaction processing.
      - SQL statements and replication
        You can run most SQL statements while replication is active. For some statements, however, you must set alter mode or stop replication.
      - Global language support for replication
        You can replicate data in non-default locales.
      - Replication between multiple server versions
        You can set up Enterprise Replication across servers of different version levels.
    - Schema design for Enterprise Replication
      When you design the database and tables for replication, you must follow the requirements and restrictions for Enterprise Replication.
    - Replication system design
      When you design a replication system, you make three main decisions: how the information flows between servers, how to resolve conflicts between replicated data, and the topology of the network of servers.
  - Setting up and managing Enterprise Replication
    After you design your replication system, you define it and start replication.
  - Push data feature
  - Loopback replication
  - Appendixes

Global language support for replication

You can replicate data in non-default locales.

An Enterprise Replication system can include databases in different locales, with the following restrictions:

When you define a database server for Enterprise Replication, that server must be running in the U. S. English locale.
The syscdr database on every Enterprise Replication server must be in the English locale.
Replicate names can be in the locale of the database.

Code-set conversion with the GLS library requires only those code-set conversion files found in the $INFORMIXDIR/gls/cv9 directory.

For U.S. English, locales are handled automatically by the installation and setup.
For non-U.S. English locales, you might need to explicitly provide the locale and conversion files.

For information about how to specify a nondefault locale and other considerations related to GLS locales, see the Informix® GLS User's Guide.