INFORMIX

This plugin allows you to monitor Informix.

Introduction

This plugin allows you to monitor Informix. It is a local plugin that uses Informix local tools to collect information. This plugin performs several tasks:

- Obtain performance information from an Informix server. This requires the "onstat", "oncheck" tool,
credentials on the database to monitor and a full path to the Informix binaries.

-Amount of size used by the facilities defined in the configuration file.

-Log file parsing.

-Availability information of an Informix server.

Compatibility

Systems where tested Centos6.6, windows server 2012, redhat 8.5
Systems where it should work Any system, Informix with Onstat y Oncheck

Plugin configuration

-Install a Pandora FMS agent inside the machine running the Informix server.

-Create and customize a specific configuration file for the plugin.

-Configure the environment variables to be used by the Pandora agent (depending on the user running the agent).
 This is an example:

#
# LOG PARSER UTILITY
#
LOGPARSER = /usr/share/pandora_agent/plugins/grep_log
DATABASES = Databases in which the databases will be monitored.
ADVANCED_TABLESPACE_MONITORING = 0 or 1. 1 will create a module for each tablespace of each database, 0 will only create a module with the sum of all tablespaces of a database.
# INSTALLATIONS
INST_NAME = custom name to identify the installation
INST_PATH = INFORMIXDIR, is the path to the installation
PSORT_DBTEMP = specifies the location where DB server writes the temporary files
PARSE_REG = Any new entry in server_path.log which match with this regular
expression will be notified through a module
SERVER LIST
SERVER_NAME = Custom name to identify the server
SERVER_PATH = server main file
SERVER_CONF = server configuration file
SECTION_END
# OPTIONAL
INST_NAME = another custom name to identify another installation
INST_PATH = path to the other installation
PSORT_DBTEMP = path
SERVER LIST
SERVER_NAME = server #1 of the other installation
SERVER_PATH = server #1 main file
SERVER_CONF = server #1 conf file
SERVER_NAM E = server #2 of the other installation
SERVER_PATH = server #2 main file
SERVER_CONF = server #2 conf ile
SECTION_END

Define the call to the plugin in your Pandora agent configuration file:

module_plugin perl /PATH/TO/FILE/informix.pl /PATH/TO/FILE/informix.conf 2> infx_error.log

Modules generated by the plugin

This is an example of execution:


This module displays the data used by the installation defined in the configuration file:

<module>
<name><![CDATA[INFORMIX space used]]></name>
<type>generic_data</type>
<data><![CDATA[2676828]]></data>
<description><![CDATA[Size of the installation in bytes]]></description>
<module_group>Informix</module_group>
</module>
<module>

This module shows whether the server is alive or not:

<name><![CDATA[INFORMIX[ol_informix1210] alive]]></name>
<type>generic_proc</type>
<data><![CDATA[1]]></data>
<description><![CDATA[]]></description>
<module_group>Informix</module_group>
</module>

Displays the number of active dbspaces on the server:

<module>
<name><![CDATA[INFORMIX[ol_informix1210] active dbspaces]]></name>
<type>generic_data</type>
<data><![CDATA[12]]></data>
<description><![CDATA[Number of active dbspaces of a max of 2047]]></description>
<module_group>Informix</module_group>
</module>

There will be one of the following modules for each db space:

<module>
<name><![CDATA[INFORMIX[ol_informix1210] rootdbs pgsize free]]></name>
<type>generic_data</type>
<data><![CDATA[83.75]]></data>
<description><![CDATA[PGSize available in %]]></description>
<module_group>Informix</module_group>
<min_warning><![CDATA[15]]></min_warning>
<max_warning><![CDATA[25]]></max_warning>
<min_critical><![CDATA[0]]></min_critical>
<max_critical><![CDATA[15]]></max_critical>
</module>

This module shows the total space occupied by the tablespaces of a database:

<module>
<name><![CDATA[Total < database > tablespaces]]></name>
<type>generic_data</type>
<data><![CDATA[4472]]></data>
<description><![CDATA[Total size asigned (PAGESIZE * NUmber pages allocated) for all tables in the database in KB]]></description>
<module_group>Informix</module_group>
</module>

This module shows the space occupied by a tablespace of a database:

<module>
<name><![CDATA[<tablespace name> space]]></name>
<type>generic_data</type>
<data><![CDATA[4472]]></data>
<description><![CDATA[Total size asigned (PAGESIZE * NUmber pages allocated) for < name table> in KB]]></description>
<module_group>Informix</module_group>
</module>

 

Finally, the plugin displays the server performance:

<name><![CDATA[CPU use [oninit]]]></name>
<type>generic_data</type>
<data><![CDATA[0.00]]></data>
<description><![CDATA[CPU use of oninit in %]]></description>
<module_group>Informix</module_group>
</module>
<module>
<name><![CDATA[Mem use [oninit]]]></name>
<type>generic_data</type>
<data><![CDATA[24.30]]></data>
<description><![CDATA[Memory in bytes of process oninit in %]]></description>
<module_group>Informix</module_group>
</module>
<module>
<name><![CDATA[Instances of [oninit]]]></name>
<type>generic_data</type>
<data><![CDATA[10]]></data>
<description><![CDATA[Number of threads of oninit]]></description>
<module_group>Informix</module_group>
</module>