Informix

Home

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

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:

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`

Search Results for {{siteSearch | truncate:'50'}}

No results.

MetricsHub MetricsHub Enterprise 2.1.00

Search Results for {{siteSearch | truncate:'50'}}

MetricsHub
MetricsHub Enterprise 2.1.00