Difference between revisions of "Informix Monitoring Subagent"

From NetXMS Wiki
Jump to navigation Jump to search
(Created page with "= Summary = NetXMS subagent for Informix (further referred to as Informix subagent) monitors one or more Informix databases and reports database-related parameters. All para...")
 
m (Text replacement - "^" to "{{deprecated}}")
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
= Summary =
{{deprecated}}#REDIRECT [[Subagent:Informix]]
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 =
 
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:
 
<syntaxhighlight lang="xml">
<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>
</syntaxhighlight>
 
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:
 
{| class="wikitable"
|-
! 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 ==
 
 
= 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.
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Session.Count(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of sessions opened
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Database.Owner(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| The owner of the database
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Database.Created(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| The database creation date
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Database.Logged(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Returns 1 if the database is logged, 0 - otherwise
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Dbspace.Pages.PageSize(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| A size of a dbspace page in bytes
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Dbspace.Pages.PageSize(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| A number of pages used in the dbspace
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Dbspace.Pages.Free(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| A number of free pages in the dbspace
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Informix.Dbspace.Pages.FreePerc(*)'''
 
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
 
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
 
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Percentage of free space in the dbspace
 
|}
 
= Informix configuration =
 
An database user must have rights to Informix system catalog tables.

Latest revision as of 16:13, 13 September 2022

This Wiki is deprecated and we are are currrently migrating remaining pages into product documentation (Admin Guide, NXSL Guide)

#REDIRECT Subagent:Informix

Retrieved from "https://wiki.netxms.org/index.php?title=Informix_Monitoring_Subagent&oldid=1819"