IBM Informix

Description

Monitors performance and operational metrics for an IBM Informix database server.

aix database ibm linux

Enterprise Connector

This connector requires the Enterprise edition of MetricsHub.

Target

Typical platform: IBM Informix

Operating systems: IBM AIX, Linux, Microsoft Windows

Prerequisites

Leverages: IBM Informix

Technology and protocols: SQL/JDBC

Examples

CLI

metricshub HOSTNAME -t aix -c +Informix --jdbc -u USER --jdbc-url URL

metricshub.yaml

resourceGroups:
  <RESOURCE_GROUP>:
    resources:
      <HOSTNAME-ID>:
        attributes:
          host.name: <HOSTNAME> # Change with actual host name
          host.type: aix
        connectors: [ +Informix ] # Optional, to load only this connector
        protocols:
          jdbc:
            port: <PORT>
            database: <DB_NAME>
            type: <type>
            url: <URL>
            username: <USERNAME> # Change with actual credentials
            password: <PASSWORD> # Encrypted using metricshub-encrypt

Connector Activation Criteria

The IBM Informix connector will be automatically activated, and its status will be reported as OK if all the below criteria are met:

• The SQL query below succeeds:
  • Query: SELECT 1 AS is_informix FROM systables WHERE LOWER(DBINFO('version','full')) LIKE '%informix%' FIRST 1;
  • Result contains: 1 (regex)

Metrics

Type	Collected Metrics	Specific Attributes
chunk_informix	db.server.storage.io{db.storage.type="chunk", db.io.direction="read"} db.server.storage.io{db.storage.type="chunk", db.io.direction="write"} db.server.storage.limit{db.storage.type="chunk"} db.server.storage.mirrored{db.storage.type="chunk"} db.server.storage.operations{db.storage.type="chunk", db.io.direction="read"} db.server.storage.operations{db.storage.type="chunk", db.io.direction="write"} db.server.storage.status{db.storage.type="chunk", db.storage.chunk.role="mirror", state="degraded|failed|ok"} db.server.storage.status{db.storage.type="chunk", db.storage.chunk.role="primary", state="degraded|failed|ok"} db.server.storage.usage{db.storage.type="chunk", db.storage.state="free"} db.server.storage.usage{db.storage.type="chunk", db.storage.state="used"}	db.server.name db.server.storage.id db.server.storage.type db.system
dbspace_informix	db.server.storage.encrypted{db.storage.type="space"} db.server.storage.limit{db.storage.type="space"} db.server.storage.mirrored{db.storage.type="space"} db.server.storage.status{db.storage.type="space", state="degraded|failed|ok"} db.server.storage.usage{db.storage.type="space", db.storage.state="free"} db.server.storage.usage{db.storage.type="space", db.storage.state="used"}	db.server.name db.server.storage.id db.server.storage.name db.server.storage.type db.system
informix	db.server.cache.operations{db.io.direction="read", db.cache.state="hit"} db.server.cache.operations{db.io.direction="read", db.cache.state="miss"} db.server.cache.operations{db.io.direction="read_sort", db.cache.state="hit"} db.server.cache.operations{db.io.direction="read_sort", db.cache.state="miss"} db.server.cache.operations{db.io.direction="write", db.cache.state="hit"} db.server.cache.operations{db.io.direction="write", db.cache.state="miss"} db.server.commits db.server.connections db.server.current_connections{db.connection.state="idle"} db.server.current_connections{db.connection.state="running"} db.server.errors{error.type="deadlocks"} db.server.informix.virtual_processors db.server.lock_waits db.server.locks db.server.rollbacks db.server.storage.io{db.io.direction="read"} db.server.storage.io{db.io.direction="write"} db.server.storage.operations{db.io.direction="read"} db.server.storage.operations{db.io.direction="write"} db.server.threads db.server.uptime	db.server.name db.system db.version id
informix_virtual_processor	db.server.informix.virtual_processor.time{db.cpu.state="system"} db.server.informix.virtual_processor.time{db.cpu.state="user"}	db.server.name informix.virtual_processor.id informix.virtual_processor.name
session_informix	db.server.cache.io{db.io.direction="read", db.cache.state="hit"} db.server.cache.io{db.io.direction="read", db.cache.state="miss"} db.server.cache.io{db.io.direction="write", db.cache.state="hit"} db.server.cache.io{db.io.direction="write", db.cache.state="miss"} db.server.commits db.server.current_locks db.server.errors{error.type="deadlocks"} db.server.lock.timeouts db.server.lock_waits db.server.locks db.server.rollbacks	db.server.client.host.id db.server.name db.server.session.id db.server.user.name db.system