Welcome
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise Replication
The describes the concepts of data replication using HCL Informix® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Appendixes
The cdr utility
You use the cdr utility to configure and control from the command line on your UNIX™ or Windows™ operating system.
Interpret the cdr utility syntax
The cdr utility uses specific terminology and conventions.
Command Abbreviations
For most commands, each of the words that make up a cdr command variation can be abbreviated to three or more characters.

HCL Informix® V15.0.0 documentation
Welcome to the documentation for HCL Informix® 15.0.0 and related client tools and products.
Product overview
HCL Informix® is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Its small footprint and self-managing capabilities are suited to embedded data-management solutions.
Installing
These topics describe how to install HCL Informix® database servers, client products, and modules.
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 HCL® Informix® Backup and Restore Guide describes how to use the HCL Informix 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 describes the concepts of data replication using HCL Informix® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
  - About Enterprise Replication
    HCL 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.
  - Setting up and managing Enterprise Replication
    After you design your replication system, you define it and start replication.
  - Push data feature
  - Loopback replication
  - Appendixes
    - The cdr utility
      You use the cdr utility to configure and control from the command line on your UNIX™ or Windows™ operating system.
      - Interpret the cdr utility syntax
        The cdr utility uses specific terminology and conventions.
        Command Abbreviations
        For most commands, each of the words that make up a cdr command variation can be abbreviated to three or more characters.
        Option Abbreviations
        Each option for a cdr command has a long form and a short form. You can use either form, and you can mix long and short forms within a single command.
        Option Order
        You can specify the options of the cdr commands in any order. Some of the syntax diagrams show the options in a specific order because it makes the diagram easier to read.
        Long Command-Line Examples
        The examples in this guide use the convention of a backslash (\) to indicate that a long command line continues on the next line.
        Long Identifiers
        Identifier names used in cdr commands follow the guidelines of SQL syntax.
        Connect Option
        Most cdr commands allow a connect option to specify the database server to connect to for performing the command.
        Participant and participant modifier
        A participant defines the data (database, table, and columns) to be replicated on a specific database server. You can choose whether to allow the participant to both send and receive replicated data, or to only receive or only send replicated data. You can choose to check for table owner permissions when applying operations. By default, permissions are not checked. The participant modifier is a restricted SELECT statement that specifies the rows and columns that are replicated.
        Return Codes for the cdr Utility
        If a cdr command encounters an error, the database server returns an error message and a return code value.
        Frequency Options
        You can specify the interval between replications or the time of day when replication occurs for a replicate.
      - cdr add onconfig
        The cdr add onconfig command adds one or more values to a configuration parameter in the ONCONFIG file.
      - cdr alter
        The cdr alter command puts the specified tables in alter mode.
      - cdr autoconfig serv
        The cdr autoconfig serv command can autoconfigure connectivity for servers in a high-availability cluster or Enterprise Replication domain, and can automatically configure replication.
      - cdr change grid
        The cdr change grid command adds or deletes replication servers to or from a grid.
      - cdr change gridtable
        The cdr change gridtable command has multiple uses. It can verify that specific tables can be used in gird queries and then add the tables to a list of verified tables, and it can delete tables from the list of verified tables.
      - cdr change onconfig
        The cdr change onconfig command replaces the existing value of a configuration parameter with a new value in the ONCONFIG file.
      - cdr change replicate
        The cdr change replicate command modifies an existing replicate by adding or deleting one or more participants.
      - cdr change replicateset
        The cdr change replicateset command changes a replicate set by adding or deleting replicates.
      - cdr change shardCollection
        The cdr change shardCollection command changes the sharding definition that determines which database servers are part of the shard cluster.
      - cdr check catalog
        The cdr check catalog command compares the metadata information related to servers, replicates and replicate sets on replication servers for any inconsistency.
      - cdr check queue
        Use the cdr check queue command to check the consistency of Enterprise Replication metadata, and to check the consistency of user data before running critical tasks in the Enterprise Replication domain. The command returns successfully when all of the commands that were queued when cdr check queue was run are complete.
      - cdr check replicate
        The cdr check replicate command compares the data on replication servers to create a report that lists data inconsistencies and can optionally repair the inconsistent data within a replicate.
      - cdr check replicateset
        The cdr check replicateset command compares the data on replication servers to create a report listing data inconsistencies. Optionally you can use the command to repair the inconsistent data within a replicate.
      - cdr check sec2er
        The cdr check sec2er command determines whether a high availability cluster can be converted to replication servers.
      - cdr cleanstart
        The cdr cleanstart command starts an server at the current log position and with empty queues.
      - cdr connect server
        The cdr connect server command reestablishes a connection to a database server that has been disconnected with a cdr disconnect server command.
      - cdr define grid
        The cdr define grid command creates a named grid of replication servers to simply administration.
      - cdr define qod
        The cdr define qod command defines a master server for monitoring the quality of data (QOD) for replication servers.
      - cdr define region
        The cdr define region command creates a region that contains a subset of the servers in a grid.
      - cdr define replicate
      - cdr define replicateset
        The cdr define replicateset command defines a replicate set on all the servers that are included as participants in the replicates. A replicate set is a collection of several replicates to be managed together.
      - cdr define server
        The cdr define server command defines a replication server in an Enterprise Replication domain. You can add a replication server to an existing domain or create a new domain.
      - cdr define shardCollection
        The cdr define shardCollection command creates a sharding definition for distributing a table or collection across multiple shard servers.
      - cdr define template
        The cdr define template command creates a template for replicates and a replicate set.
      - cdr delete grid
        The cdr delete grid command deletes the specified grid.
      - cdr delete region
        The cdr delete region command deletes a region from a grid.
      - cdr delete replicate
        The cdr delete replicate command deletes a replicate.
      - cdr delete replicateset
        The cdr delete replicateset command deletes an exclusive or non-exclusive replicate set from the global catalog.
      - cdr delete server
        The cdr delete server disables a database server from participating in Enterprise Replication.
      - cdr delete shardCollection
        The cdr delete shardCollection command deletes a sharding definition, and then stops data sharding.
      - cdr delete template
        The cdr delete template command deletes a template from the replication domain. It also deletes any underlying replicate sets associated with the template (these will exist if the template has been realized). No replicates are deleted.
      - cdr disable grid
        The cdr disable grid command removes the authorization to run grid routines from users or servers.
      - cdr disable server
        The cdr disable server command disables replication on a server.
      - cdr disconnect server
        The cdr disconnect server command stops a server connection.
      - cdr enable grid
        The cdr enable grid command authorizes users to run commands on the grid and designates servers from which grid commands can be run.
      - cdr enable server
        The cdr enable server command enables replication on a replication server that was disabled by the cdr disable server command.
      - cdr error
      - cdr finderr
        The cdr finderr command looks up a specific return code and displays the corresponding error text.
      - cdr list grid
        The cdr list grid command shows information about a grid.
      - cdr list replicate
        The cdr list replicate command displays information about the replicates on the current server.
      - cdr list replicateset
        The cdr list replicateset command displays information about the replication sets defined on the current server.
      - cdr list server
        The cdr list server command displays a list of the Enterprise Replication servers that are visible to the server on which the command is run.
      - cdr list shardCollection
        The cdr list shardCollection command displays the sharding definition for all database servers in a shard cluster.
      - cdr list catalog
        The cdr list catalog command lists the commands that created the specified replication objects.
      - cdr list template
        The cdr list template command displays information about the templates on the server on which the command is run.
      - cdr migrate server
        The cdr migrate server command automates data migration task between two or more servers. This command also automates setting up of Enterprise Replication between two Informix server instances.
      - cdr modify grid
        The cdr modify grid command modifies grid attributes.
      - cdr modify replicate
        The cdr modify replicate command modifies replicate attributes.
      - cdr modify replicateset
        The cdr modify replicateset command modifies all the replicates in a replicate set.
      - cdr modify server
        The cdr modify server command modifies the Enterprise Replication attributes of a database server.
      - cdr realize template
        The cdr realize template command creates the replicates, replicate set, and participant tables as specified in a template, and then synchronizes data on all or a subset of the database servers within the replication domain.
      - cdr remaster
        The cdr remaster command changes the SELECT clause or the server from which to base the master replicate definition of an existing master replicate. This command can also convert a classic (non-master) replicate to a master replicate.
      - cdr remaster gridtable
        The cdr remaster gridtable command validates tables in a grid after an alter operation.
      - cdr remaster replicateset
        The cdr remaster replicateset command updates the definitions of the set of replicates whose participants were changed by ALTER operations.
      - cdr remove onconfig
        The cdr remove onconfig command removes the specified value from a configuration parameter in the ONCONFIG file.
      - cdr repair
        The cdr repair command synchronizes data based on ATS or RIS files.
      - cdr reset qod
        The cdr reset qod command resets failed-transaction counts for replicates on replicate servers. Connection Manager service-level agreements (SLA) that contains a FAILURE or LATENCY redirection policy use failed-transaction counts to determine where to route client requests.
      - cdr resume replicate
        The cdr resume replicate command resumes delivery of replication data.
      - cdr resume replicateset
        The cdr resume replicateset command resumes delivery of replication data for all the replicates in a replicate set.
      - cdr resume server
        The cdr resume server command resumes delivery of replication data to a suspended database server.
      - cdr start
        The cdr start command starts Enterprise Replication processing.
      - cdr start qod
        The cdr start qod command starts quality of data (QOD) monitoring for replication servers.
      - cdr start replicate
        The cdr start replicate command starts the capture and transmittal of replication transactions.
      - cdr start replicateset
        The cdr start replicateset command starts the capture and transmittal of replication transactions for all the replicates in a replicate set.
      - cdr start sec2er
        The cdr start sec2er command converts a high availability cluster to replication servers.
      - cdr stats rqm
        The cdr stats rqm command displays information about the reliable queue manager (RQM) queues used for Enterprise Replication.
      - cdr stats recv
        The cdr stats recv command displays receiver parallelism statistics and latency statistics by source node.
      - cdr stats check
        The cdr stats check command displays the progress of a consistency check that specified a progress report task name.
      - cdr stats sync
        The cdr stats sync command displays the progress of a synchronization operation that specified a progress report task name.
      - cdr stop
        The cdr stop command stops replication on the server to which you are connected without shutting down the database server.
      - cdr stop qod
        The cdr stop qod command stops quality of data (QOD) monitoring for replication servers.
      - cdr stop replicate
        The cdr stop replicate command stops the capture, transmittal, and reception of transactions for replication.
      - cdr stop replicateset
        The cdr stop replicateset command stops capture and transmittal transactions for all the replicates in a replicate set.
      - cdr suspend replicate
        The cdr suspend replicate command suspends delivery of replication data.
      - cdr suspend replicateset
        The cdr suspend replicateset command suspends delivery of replication data for all the replicates in a replicate set.
      - cdr suspend server
        The cdr suspend server command suspends the delivery of replication data to a database server from either a specified list of database servers or from all database servers in the domain.
      - cdr swap shadow
        The cdr swap shadow command switches a replicate with its shadow replicate during manual remastering.
      - cdr sync replicate
        The cdr sync replicate command synchronizes data among replication servers to repair inconsistent data within a replicate.
      - cdr sync replicateset
        ASDF The cdr sync replicateset command synchronizes data among replication servers to repair inconsistent data within a replicate set.
      - cdr -V
        The cdr -V command displays the version of that is currently running.
      - cdr view
        The cdr view command shows information about every server in the domain.
    - configuration parameter and environment variable reference
      You can use configuration parameters and environment variables to configure the behavior of .
    - Grid routines
      Grid routines are used to create and maintain the grid and to administer servers in the grid by propagating commands from a source server to all other servers in the grid.
    - Enterprise Replication routines
      Enterprise Replication routines used to control if a replicated transaction is recaptured.
    - onstat -g commands for Enterprise Replication
      You can monitor and debug Enterprise Replication activity using onstat -g commands.
    - syscdr Tables
      These tables in the syscdr database contain progress information about consistency checking and synchronization operations.
    - SMI Table Reference
      The system-monitoring interface (SMI) tables in the sysmaster database provide information about the state of the database server. Enterprise Replication uses the following SMI tables.
    - Replication Examples
      This appendix contains simple examples of replication using the command-line utility (CLU).
    - Data sync warning and error messages
      Data sync warning and error messages describe problems with replicated transactions.
Migrating and upgrading
You can upgrade to the 15.0.0 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
Embedding Informix®
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Designing databases
The first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
Security
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Troubleshooting HCL Informix®
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.

Command Abbreviations

For most commands, each of the words that make up a cdr command variation can be abbreviated to three or more characters.

For example, the following commands are all equivalent:

cdr define replicate
cdr define repl
cdr def rep

The exceptions to this rule are the replicateset commands, which can be abbreviated to replset. For example, the following commands are equivalent:

cdr define replicateset
cdr def replset

Command abbreviations are not allowed when you run cdr commands within SQL statements using the SQL administration API. For more information, see the HCL® Informix® Administrator's Reference.