Using Command-Line Utilities

The header information displayed every time you execute onstat has a field to indicate if a database server is operating as a primary or secondary database server.

The following example shows a header for a database server that is the primary database server in a replication pair, and in online mode:

IBM Informix Dynamic
Server Version 9.30.UC1     -- online(Prim) -- Up 45:08:57

This example shows a database server that is the secondary database server in a replication pair, and in read-only mode.

IBM Informix Dynamic Server Version 9.30.UC1     -- Read-Only (Sec) -- Up 45:08:57

The following example shows a header for a database server that is not involved in HDR. The type for this database server is standard.

IBM Informix Dynamic Server Version 9.30.UC1     -- online -- Up 20:10:57

onstat -g dri

To obtain full HDR monitoring information, execute the onstat -g dri option. The following fields are displayed:

• The database server type (primary, secondary, or standard)
• The HDR state (on or off)
• The paired database server
• The last HDR checkpoint
• The values of the HDR configuration parameters

For an example of onstat -g dri output, see the IBM Informix Administrator's Reference.

oncheck -pr

If your database server is running HDR, the reserved pages PAGE_1ARCH and PAGE_2ARCH store the checkpoint information that HDR uses to synchronize the primary and secondary database servers. An example of the relevant oncheck -pr output is given in Figure 81.

Validating Informix Database Server reserved pages - PAGE_1ARCH &
 PAGE_2ARCH
          Using archive page PAGE_1ARCH.

    Archive Level                  0
    Real Time Archive Began        01/11/95 16:54:07
    Time Stamp Archive Began       11913
    Logical Log Unique Id          3
    Logical Log Position           b018

    DR Ckpt Logical Log Id         3
    DR Ckpt Logical Log Pos        80018
    DR Last Logical Log Id         3
    DR Last Logical Log Page       128