Informix Monitoring Subagent
| This Wiki is deprecated and we are are currrently migrating remaining pages into product documentation (Admin Guide, NXSL Guide) |
Summary
NetXMS subagent for Informix (further referred to as Informix subagent) monitors one or more Informix databases and reports database-related parameters.
All parameters available from Informix subagent gathered or calculated once per minute thus its recommended to set DCI poll interval for these items to 60 seconds or more. All parameters are obtained or derived from the data available in Informix system catalogs. Informix subagent does not monitor any of the metrics related to lower level database layers, such as database processes. Monitoring of such parameters can be achieved through the standard NetXMS functionality.
Configuration
ODBC.INI
Create ~/.odbc.ini (adjust Driver, Database and Servername):
[ODBC Data Sources]
ifx=IBM INFORMIX ODBC DRIVER
[ifx]
Driver=/informix_v11_50/lib/cli/iclit09b.so
Database=sysmaster
Servername=informix_v11
Subagent can be configured using XML configuration file (usually created as separate file in configuration include directory), or in simplified INI format, usually in main agent configuration file.
XML configuration
There is a sample Informix subagent configuration file in XML format:
<config>
<agent>
<subagent>c:\netxms\bin\informix.nsm</subagent>
</agent>
<informix>
<databases>
<database id="1">
<id>TEST_IFX_DB</id>
<name>MYIFX</name> <!-- DSN -->
<server>MYIFX</server>
<username>informix</username>
<password>informix</password>
</database>
</databases>
</informix>
</config>
You can specify multiple databases in the informix section. Each database description must be surrounded by database tags with the id attribute. id can be any unique integer, it instructs the Informix subagent about the order in which database sections will be processed.
Each database definition supports the following parameters:
| Parameter | Description | Default value |
|---|---|---|
| Id | Database identifier. It will be used to address this database in parameters. | empty |
| Name | Database name. This is a name of Informix DSN. | empty |
| Server | Name of the Informix server. | empty |
| UserName | User name for connecting to database. | empty |
| Password | Database user password. | empty |
INI configuration
Subagent=informix.nsm
*informix
ID=db1
DBName = instance1
DBLogin = user
DBPassword = password
Provided Parameters
The Informix subagent supports a number of Informix.* DCI parameters. Currently, all of them accept a database id (the one specified in “Id” tag in the subagent configuration file) as the only input parameter.
| Informix.Session.Count(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | Number of sessions opened |
| Informix.Database.Owner(*) | |
| Input | Database id |
| Return type | DCI_DT_STRING |
| Description | The owner of the database |
| Informix.Database.Created(*) | |
| Input | Database id |
| Return type | DCI_DT_STRING |
| Description | The database creation date |
| Informix.Database.Logged(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | Returns 1 if the database is logged, 0 - otherwise |
| Informix.Dbspace.Pages.PageSize(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | A size of a dbspace page in bytes |
| Informix.Dbspace.Pages.PageSize(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | A number of pages used in the dbspace |
| Informix.Dbspace.Pages.Free(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | A number of free pages in the dbspace |
| Informix.Dbspace.Pages.FreePerc(*) | |
| Input | Database id |
| Return type | DCI_DT_INT |
| Description | Percentage of free space in the dbspace |
Informix configuration
An database user must have rights to Informix system catalog tables.