Geneos


The end of life (EOL) date for this module is on 31 July, 2019.

Informix Plug-In - Technical Reference

Introduction

Geneos Informix Plug-In monitors the health and status of a server running the Informix Relational Database Management System (RDBMS).

Views

The Informix Plug-In produces two views, Status and Capacity.

Status View

Displays information about the general status of the Informix database instance that is being monitored.

informix_image2

Status Table Legend

NameDescription
VersionCurrent Informix release.
statusShould be On-Line, will display Prim if this is a primary server.
uptimeTime this server has been alive for.
memoryAvailable RAM for this server.
replicationTypeWill show primary or secondary or standard if no replication occurs.
replicationStateOn or off.
pairedServerShows the server this database is replicating to if replication is enabled.
DRIntervalSpecifies the maximum time interval in seconds between flushing the data replication buffer on the primary. This parameter can be set to -1, 0 and positive integer values. When this is set to -1, the primary waits for the secondary to confirm acceptance of the replication buffer. With synchronous updating, no transactions committed on the primary are left uncommitted or partially committed on the secondary. Synchronous updating can impact perceived performance significantly, as the primary can only move on once it has obtained confirmation that the secondary has the required data committed. When set to 0 or greater, there may be transactions that have been committed on the primary, which would have been rolled back on the secondary if there has been a failure.
DRTimeoutSpecifies the wait-time in seconds that an Online server in an HDR pair waits for confirmation from the other server that the replication buffer has been successfully transferred. Multiply the DRTIMEOUT by 4 to evaluate the actual elapsed time that will occur before a replication failure is determined.
DRAutoAuto failover status - 0 or OFF - do not automatically switch, 1 or RETAIN_TYPE - automatically switch secondary to standard on HDR failure, 2 or REVERSE_TYPE - automatically switch secondary to standard on an HDR failure. Switch to primary (and primary to secondary) when HDR can restart.
DRLostFoundIf not using synchronous data replication, then this file will hold details of any transactions that did not get replayed on the secondary.

Capacity View

Monitors disk utilisation statistics for the database.

informix_image3

CAPACITY Table Legend

NameDescription
dbSpaceName of the particular database area.
totalPagesTotal 2k pages available in that area.
pagesUsedNumber of utilised pages per area.
pagesFreeNumber of unutilised pages per area.
percentFreeSpacePercentage space available per area.
percentUtilisationPercentage space used per area.

Plug-In Configuration

Sample Configuration:

capacityScript: /export/home/informix/dbscap.csh
statusScript: /export/home/informix/dbstat.csh

The following parameters can be configured for this plug-in:

capacityScript

The full path to the Informix Capacity Script.

The script should set environment variables and execute the command dbaccess < dbsfree.sql.

Mandatory: [Yes]

statusScript

The full path to the Informix Status Script.

The script should execute the command onstat -g dri.

Mandatory: [Yes]