Prerequisites for adding an Informix monitor (with SSH-based monitoring)

Prerequisites for adding an Informix monitor (with SSH-based monitoring)

  1. Applications Manager collects Informix metrics by executing onstat and OS commands on the database server over SSH. Please ensure the following before adding the monitor.

    1. Network connectivity

    • The Applications Manager server must be able to reach the Informix database server on the SSH port (default 22). If a custom SSH port is used, note it — it must be entered in the OS Port field while adding the monitor.
    • Ensure firewall rules permit this connection.
    • The Informix database port (default 9088) must also be reachable for JDBC-based metric collection.

    2. SSH service on the database server

    • SSH daemon (sshd) must be installed and running on the Informix host.
    • Password authentication must be enabled. Key-based-only SSH is not currently supported for command-line monitoring.

    3. Monitoring OS account

    Provide a dedicated OS user account on the database server with:

    • A valid login shell (e.g., /bin/bash) — restricted or nologin shells are not supported.
    • An active, non-expired password (expired passwords cause the connection to fail).
    • Membership in the informix OS group (or use the informix user itself) so that onstat commands can attach to the Informix shared memory.
    • (Optional, for Audit Configuration metrics): the informix user or a user with the AAO role (ix_aao group where role separation is enabled) is required to run onaudit -c. Without this, all metrics except audit configuration will still be collected.

    4. Informix environment for the monitoring account

    The following variables must be exported in the account's login profile (~/.profile, ~/.bash_profile, or /etc/profile), since commands are executed in a non-interactive SSH session:

    • INFORMIXDIR
    • INFORMIXSERVER
    • ONCONFIG
    • INFORMIXSQLHOSTS (if not in the default location)
    • PATH including $INFORMIXDIR/bin

    5. Commands executed by the Informix monitor

    The monitoring account must be able to run the following (no sudo is used; the account itself needs these rights):

    • Informix: onstat -, onstat -d, onstat -l, onstat -k, onstat -u, onstat -g ckp/sql/ath/ses/seg/dri/rss
    • Audit : onaudit -c
    • OS-level: uptime, uname -s, ipcs -q, ipcs -m, ipcs -s, and disk usage (df -k on Linux, df -h on AIX, bdf on HP-UX)

    Before adding the monitor, verify from the Applications Manager server:

    ssh <monitoring_user>@<informix_host> 'onstat -'

    This should return the Informix server status block without any "permission denied" or "command not found" errors. This is the same check Applications Manager performs while adding the monitor — if it succeeds manually, monitor addition will pass validation.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Real User Monitor (RUM) - Troubleshooting guide

                        If your Real User Monitor has not collected data for an extended period, follow the steps below to troubleshoot the issue. Step 1: Verify the RUM Agent configuration Real User Monitoring requires the RUM Agent to be installed and mapped to ...
                      • Memory Usage Calculation (Linux- Telnet/SSH)

                        Physical Memory Utilization Calculation: Note: For version 16800 and above , the Skip option will be under Settings -> Performance Polling -> Servers -> Linux monitor type. Formula: (i) If Skip buffer and cache from monitoring (Applicable only for ...
                      • Windows Monitoring - FAQ

                        This Knowledge Base article provides answers to frequently asked questions related to Windows Server monitoring through WMI. The articles are categorized based on the monitoring lifecycle to help you quickly identify the relevant troubleshooting ...
                      • Amazon VPC Monitoring – Prerequisites and Troubleshooting Guide

                        This document outlines the prerequisites, required AWS IAM permissions, and configuration steps needed to enable Amazon VPC monitoring using VPC Flow Logs, Amazon Athena, and AWS Glue in Applications Manager. It also provides troubleshooting guidance ...
                      • Self monitor Applications Manager using APM Insight Java Agent

                        Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...