Database Monitoring

Informix Monitoring

The NimBUS for Informix Monitoring solution includes a specialized probe, which will execute selected SQL to extract vital information about your Informix databases. Status data collected by the probe is analyzed for alert generation, and archived for performance and SLA reporting.

The probe continuously monitors the internal performance and space allocation throughout the Informix database - alerts are forwarded to the NimBUS Availability Manager for appropriate alert notification when required.

An extensive range of checkpoints can be selected to meet the needs of specific monitoring requirements. Below is a listing of Informix database metrics that are monitoring by the NimBUS for Informix Monitoring solution:

• Logging the status each Informix database
• Database free space (percent and MB)
• Buffer cache hit ratio for reads and writes
• Table extents and table size (MB)
• Users waiting for locks
• Chunk I/O read and write statistics
• Virtual cpu user- and system time
• Connectivity to the database server
• Uptime (in days) of the database server

Report generation is available for the following:

• Number of Informix databases
• Attempts to exceed the maximum number of locks and threads
• Failed attempts to allocate entries in the transaction table
• Number of times threads had to wait for a latch or a buffer
• Number of times sessions had to wait for a lock
• Number of times threads had to wait for critical section checkpoints
• Number of times potential deadlocks are detected and prevented
• Number of times distributed deadlock timeout is exceeded while user is waiting for lock
• Foreground writes, LRU writes and chunk writes
• Users waiting for locks

The NimBUS for Informix Monitoring solution requires minimal effort for implementation, training, and will not require extensive ongoing maintenance.

If you would like to request a free trial of NimBUS, please click here. For free white papers or additional information click here.