Connectors directory[1]   Full listing of connectors[2]

Informix

Description

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

database[3] enterprise[4] linux[5] windows[6]

Target

Typical platform: IBM Informix[7]

Operating systems: Linux, Microsoft Windows

Prerequisites

Leverages: IBM Informix

Technology and protocols: SQL/JDBC

Examples

CLI

metricshub HOSTNAME -t linux -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: linux
        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 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 on the monitored database:
      • SQL Query: SELECT 1 AS is_informix FROM systables WHERE LOWER(DBINFO('version','full')) LIKE '%informix%' FIRST 1;
      • Expected Result: 1

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
No results.