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.
Appendixes
onstat -g commands for Enterprise Replication
You can monitor and debug Enterprise Replication activity using onstat -g commands.
onstat -g nif: Print statistics about the network interface
Prints statistics about the network interface.

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.
  - 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 Enterprise Replication from the command line on your UNIX™ or Windows™ operating system.
    - Enterprise Replication configuration parameter and environment variable reference
      You can use configuration parameters and environment variables to configure the behavior of Enterprise Replication.
    - 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.
      - Threads shown by the onstat -g ath command
        The threads that Enterprise Replication uses are shown by the onstat -g ath command.
      - onstat -g cat: Print ER global catalog information
        Prints information from the Enterprise Replication global catalog.
      - onstat -g cdr: Print ER statistics
        Prints the output for all of the Enterprise Replication statistics commands.
      - onstat -g cdr config
        Prints the settings of Enterprise Replication configuration parameters and environment variables that can be set with the CDR_ENV configuration parameter.
      - onstat -g ddr
        Prints the status of the Enterprise Replication database log reader.
      - onstat -g dss: Print statistics for data sync threads
        Prints detailed statistical information about the activity of individual data sync threads.
      - onstat -g dtc: Print statistics about delete table cleaner
        Prints statistics about the delete table cleaner.
      - onstat -g grp
        Prints statistics about the grouper.
      - onstat -g nif: Print statistics about the network interface
        Prints statistics about the network interface.
      - onstat -g que: Print statistics for all ER queues
        Prints statistics that are common to all queues.
      - onstat -g rcv: Print statistics about the receive manager
        Prints statistics about the Enterprise Replication receive manager. The receive manager is a set of service routines between the receive queues and data sync. The onstat -g rcv command is used primarily as a debugging tool and by Informix® Software Support. If you suspect that acknowledgment messages are not being applied, you can run this command.
      - onstat -g rep
        Prints events that are in the queue for the schedule manager.
      - onstat -g rqm
        Prints statistics and contents of the low-level queues (send queue, receive queue, ack send queue, sync send queue, and control send queue) managed by the Reliable Queue Manager (RQM).
      - onstat -g sync
        Prints statistics about the active synchronization process.
    - 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.

onstat -g nif: Print statistics about the network interface

Prints statistics about the network interface.

The output shows which sites are connected and provides a summary of the number of bytes sent and received by each site. This can help you determine if a site is not sending or receiving bytes.

The onstat -g nif option is used primarily as a debugging tool and by Informix® Software Support.

The following table describes the options for onstat -g nif command:

Table 1. Options for the onstat -g nif command
Option	Action
all	Prints the sum and the sites.
sites	Prints the NIF site context blocks.
`server_ID`	Prints information about the replication server with that server ID.
sum	Prints the sum of the number of buffers sent and received for each site.

Example Output

The following example shows output for the onstat -g nif command. In this example, the local server is connected to the server group g_bombay and its CDR ID is 200. The connection status is running. The connection between the two servers is running, but the replication state on the g_bombay server is suspended. The server group g_bombay internal NIF version is 9. The local server has sent three messages to the server g_bombay and it has received two messages from g_bombay.

$ onstat -g nif

NIF anchor Block: af01610
       nifGState         RUN
          RetryTimeout   300

CDR connections:
 Id    Name       State    Version    Sent   Received
 -----------------------------------------------------
 200 g_bombay     RUN,SUSPEND    9       3          2

Output Description

NIF anchor Block: The address of the network storage block.
nifGState: The connection state.
RetryTimeout: The number of seconds before Enterprise Replication attempts to retry a dropped connection.
Id: The Enterprise Replication ID number for the server.
Name: The name of the server group.
State: The connection state between the local server and the listed server. If multiple states are shown the second state designates the replication state.
Version: The internal version number of the NIF component on the listed server.
Sent: The number of messages the local server has sent to the listed server.
Received: The number of messages received by the local server from the listed server.