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 dtc: Print statistics about delete table cleaner
Prints statistics about the delete table cleaner.

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 dtc: Print statistics about delete table cleaner

Prints statistics about the delete table cleaner.

The delete table cleaner removes rows from the delete table when they are no longer needed.

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

In the following example, the thread name of the delete table cleaner is CDRDTCleaner. The total number of rows deleted is 1. The last activity on this thread occurred at 2010/08/13 18:47:19. The delete table for replicate rep1 was last cleaned at 2010/08/13 18:28:25.

-- Up 00:59:15 -- 28672 Kbytes
-- Delete Table Cleanup Status as of (1095119368) 2010/08/13 18:49:28
thread           = 49 <CDRDTCleaner>
      rows deleted     = 1
      lock timeouts    = 0
      cleanup interval = 300
      list size        = 3
      last activity    = (1095119239) 2010/08/13 18:47:19

Id      Database                         Last Cleanup Time
        Replicate            Server              Last Log Change
=========================================================
000001  test                             (1095118105) 2010/09/13
  18:28:25
        rep1                 g_bombay            (1095118105) 2010
        /08/13 18:28:25
        rep1                 g_delhi             (1095118105) 2010
        /08/13 18:28:25
000002  test                             <never cleaned>