EOL

Effective 31 July 2019, Informix reached end of life. This documentation is archived and will no longer be updated.

Informix

Introduction Copied

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

Views Copied

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

Status View Copied

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

informix_image2

Status Table Legend

Name Description
Version Current Informix release.
status Should be On-Line, will display Prim if this is a primary server.
uptime Time this server has been alive for.
memory Available RAM for this server.
replicationType Will show primary or secondary or standard if no replication occurs.
replicationState On or off.
pairedServer Shows the server this database is replicating to if replication is enabled.
DRInterval Specifies 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.
DRTimeout Specifies 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.
DRAuto Auto 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.
DRLostFound If not using synchronous data replication, then this file will hold details of any transactions that did not get replayed on the secondary.

Capacity View Copied

Monitors disk utilisation statistics for the database.

informix_image3

CAPACITY Table Legend

Name Description
dbSpace Name of the particular database area.
totalPages Total 2k pages available in that area.
pagesUsed Number of utilised pages per area.
pagesFree Number of unutilised pages per area.
percentFreeSpace Percentage space available per area.
percentUtilisation Percentage space used per area.

Plug-In Configuration Copied

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 Copied

The full path to the Informix Capacity Script.

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

Mandatory: [Yes]

statusScript Copied

The full path to the Informix Status Script.

The script should execute the command onstat -g dri.

Mandatory: [Yes]

["Geneos"] ["Geneos > Netprobe"] ["Technical Reference"] "1"

Was this topic helpful?