IBM DB2
Overview
IBM DB2, the robust and scalable relational database management system, seamlessly integrates with Motadata AIOps to provide comprehensive monitoring and management capabilities. With this integration, organizations gain real-time visibility into the performance and health of their DB2 databases. Monitor critical database metrics such as query execution times, transaction rates, and storage utilization to ensure efficient data processing.
Supported Versions
| Versions |
|---|
| 11 |
| 12 |
| 11.5.0.1077 |
| 9.7.900.250(windows) |
| 10.5.0.11(solaris) |
Prerequisites for IBM DB2 Integration with Motadata AIOps:
Ensure that the IBM DB2 port (default: 50000) is open for the Motadata AIOps server.
Ensure you have the necessary credentials, including the username and password, for Motadata AIOps to connect to the IBM DB2 database.
Ensure that JDBC is supported on the server where IBM DB2 is configured.
For agentless monitoring, ensure that the user has the required access for remote access to the IBM DB2 database server. For agent-based monitoring, this is not required.
Ensure that the IBM DB2 service is active and running on the server.
Ensure you have the name of the IBM DB2 database that you want to monitor.
Confirm that the IBM DB2 process and service are listed in the process and service monitor settings of Motadata AIOps. While these may be listed by default, verify that the names of the service and process match the specific IBM DB2 version that you intend to monitor.
By following these prerequisites, you can integrate IBM DB2 with Motadata AIOps and ensure smooth functioning of the monitoring process.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| system.tags | The tags associated with the Db2 system. | String |
| db2.instance.status | The status of the Db2 instance. | String |
| db2.private.committed.memory.bytes | The amount of private committed memory used by Db2. | Count |
| db2.accepted.piped.sorts | The number of piped sorts accepted by Db2. | Count |
| db2.requested.piped.sorts | The number of piped sorts requested by Db2. | Count |
| db2.local.connections | The number of local connections to Db2. | Count |
| db2.remote.connections | The number of remote connections to Db2. | Count |
| db2.active.gateway.connections | The number of active gateway connections in Db2. | Count |
| db2.gateway.client.connection.waits | The number of client connection waits in Db2 gateway. | Count |
| db2.gateway.host.connection.waits | The number of host connection waits in Db2 gateway. | Count |
| db2.gateway.connections | The number of connections in Db2 gateway. | Count |
| db2.executing.local.connections | The number of executing local connections in Db2. | Count |
| db2.local.databases.with.current.connects | The number of local databases with current connects in Db2. | Count |
| db2.executing.remote.connections | The number of executing remote connections in Db2. | Count |
| db2.registered.agents | The number of registered agents in Db2. | Count |
| db2.waiting.on.token.agents | The number of agents waiting on tokens in Db2. | Count |
| db2.idle.agents | The number of idle agents in Db2. | Count |
| db2.sort.heap.allocation.bytes | The amount of sort heap memory allocated by Db2. | Count |
| db2.stolen.agents | The number of stolen agents in Db2. | Count |
| db2.pool.agents | The number of agents in the Db2 pool. | Count |
| db2.created.agents.empty.pool | The number of agents created when the pool is empty in Db2. | Count |
| db2.version | The version of Db2. | String |
| db2.last.snapshot | The timestamp of the last Db2 snapshot. | Count |
| db2.last.reset | The timestamp of the last Db2 reset. | Count |
| db2.partition.number | The number of partitions in Db2. | Count |
| db2.nodes | The number of nodes in Db2. | Count |
| db2.active.agents | The number of active agents in Db2. | Count |
| db2.sort.heap.used.percent | The percentage of sort heap memory used by Db2. | Count |
| db2.connections | The number of active connections to Db2. | Count |
| started.time | The timestamp when Db2 was started. | String |
| started.time.sec | The number of seconds since Db2 was started. | Count |
| db2.database.size.bytes | The size of the Db2 database in bytes. | Count |
| db2.table.space | Db2 table space. | Count |
| db2.table.space.name | The name of the Db2 table space. | Count |
| db2.table.space.type | The type of the Db2 table space. | Count |
| db2.table.space.content.type | The content type of the Db2 table space. | Count |
| db2.table.space.created | The creation timestamp of the Db2 table space. | Count |
| db2.table.space.status | The status of the Db2 table space. | Count |
| db2.table.space.size.bytes | The size of the Db2 table space in bytes. | Count |
| db2.table.space.used.bytes | The amount of used space in the Db2 table space in bytes. | Count |
| db2.table.space.free.bytes | The amount of free space in the Db2 table space in bytes. | Count |
| db2.table.space.used.percent | The percentage of used space in the Db2 table space. | Count |
| db2.table.space.page.size.bytes | The size of a page in the Db2 table space in bytes. | Count |
| db2.table.space.page.usable.bytes | The usable space in a page of the Db2 table space in bytes. | Count |
| db2.table.space.containers | The number of containers in the Db2 table space. | Count |
| db2.table.space.extent.pages | The number of extent pages in the Db2 table space. | Count |
| db2.table.space.prefetch.pages | The number of prefetch pages in the Db2 table space. | Count |
| db2.blocked.sessions | The number of blocked Db2 sessions. | Count |
| db2.waiting.sessions | The number of waiting Db2 sessions. | Count |
| db2.active.sessions | The number of active Db2 sessions. | Count |
| db2.sessions | The total number of Db2 sessions. | Count |
| correlation.metrics | The correlation metrics. | String |
| db2.session.agent.id | The agent ID of a Db2 session. | Count |
| db2.session.application | The application associated with a Db2 session. | Count |
| db2.session.application.status | The status of the application associated with a Db2 session. | Count |
| db2.session.read.rows | The number of rows read by a Db2 session. | Count |
| db2.session.written.rows | The number of rows written by a Db2 session. | Count |
| db2.session.data.reads.rate | The rate of data reads by a Db2 session. | Count |
| db2.session.index.reads | The number of index reads by a Db2 session. | Count |
| db2.session.data.writes.rate | The rate of data writes by a Db2 session. | Count |
| db2.session.index.writes | The number of index writes by a Db2 session. | Count |
| db2.session.physical.read.time.ms | The amount of time spent on physical reads by a Db2 session (in milliseconds). | Count |
| db2.session.physical.write.time.ms | The amount of time spent on physical writes by a Db2 session (in milliseconds). | Count |
| db2.session.lock.held | The number of locks held by a Db2 session. | Count |
| db2.session.lock.wait | The number of lock waits for a Db2 session. | Count |
| db2.session.lock.wait.time.ms | The total wait time for locks in milliseconds for a Db2 session. | Count |
| db2.session.deadlocks | The number of deadlocks encountered by a Db2 session. | Count |
| db2.session.sorts | The number of sorts performed by a Db2 session. | Count |
| db2.session.commit.sql.statements | The number of SQL COMMIT statements executed by a Db2 session. | Count |
| db2.session.rollback.sql.statements | The number of SQL ROLLBACK statements executed by a Db2 session. | Count |
| db2.session.deleted.rows | The number of rows deleted by a Db2 session. | Count |
| db2.session.inserted.rows | The number of rows inserted by a Db2 session. | Count |
| db2.session.updated.rows | The number of rows updated by a Db2 session. | Count |
| db2.session.selected.rows | The number of rows selected by a Db2 session. | Count |
| db2.session.timedout.locks | The number of locks that have timed out for a Db2 session. | Count |
| db2.session.agents | The number of agents associated with a Db2 session. | Count |
| db2.session.cpu.time.sec | The CPU time consumed by a Db2 session in seconds. | Count |
| db2.session.statement.execution.elapsed.time.sec | The elapsed time for executing SQL statements in seconds for a Db2 session. | Count |
| db2.session.user.id | The user ID associated with a Db2 session. | Count |
| db2.session.remote.client | The remote client of a Db2 session. | Count |
| db2.session.agent.id | The agent ID of a Db2 session holding a lock. | Count |
| db2.session.application | The application associated with a Db2 session. | Count |
| db2.session.table.name | The name of the table involved in a Db2 session. | Count |
| db2.session.lock.type | The type of lock held by a Db2 session. | Count |
| db2.session.lock.status | The status of the lock held by a Db2 session. | Count |
| db2.session.lock.mode | The mode of the lock held by a Db2 session. | Count |
| db2.session.agent.id.holding.lock | The agent ID of the session holding the lock. | Count |
| db2.session.lock.wait.agent.id | The agent ID of the session waiting for the lock. | Count |
| db2.session.lock.mode.requested | The lock mode requested by a Db2 session. | Count |
| db2.session.lock.wait.start.time | The start time of the lock wait for a Db2 session. | Count |
| db2.memory.pool | The total number of Db2 memory pools. | Count |
| db2.memory.pool.size.bytes | The size of the Db2 memory pool in bytes. | Count |
| db2.memory.pool.used.bytes | The amount of Db2 memory pool used in bytes. | Count |
| db2.buffer.pool | The total number of Db2 buffer pools. | Count |
| db2.buffer.pool.hit.ratio.percent | The hit ratio percentage of the Db2 buffer pool. | Count |
| db2.backup | Total number of Db2 backups. | Count |
| db2.backup.id | ID of the Db2 backup. | Count |
| db2.backup.status | Status of the Db2 backup. | Count |
| db2.backup.location | Location of the Db2 backup. | Count |
| db2.backup.operation.type | Type of operation performed during the Db2 backup. | Count |
| db2.backup.object.type | Type of object being backed up in Db2. | Count |
| db2.backup.table.spaces | Number of table spaces included in the Db2 backup. | Count |
| db2.backup.table.space | Specific table space included in the Db2 backup. | Count |
| db2.backup.start.time | Start time of the Db2 backup. | Count |
| db2.backup.end.time | End time of the Db2 backup. | Count |
| db2.backup.duration.seconds | Duration of the Db2 backup in seconds. | Count |
| started.time.sec | Number of seconds since the database was started. | Count |
| started.time | Time when the database was started. | String |
| db2.db.path | File path of the Db2 database. | Count |
| db2.db.status | Status of the Db2 database. | Count |
| db2.db.alias | Alias of the Db2 database. | Count |
| db2.db.last.backup | Last backup performed on the Db2 database. | Count |
| db2.db.location | Location of the Db2 database. | Count |
| db2.db.dynamic.sql.queries | Number of dynamic SQL queries executed on the Db2 database. | Count |
| db2.db.failed.sql.queries | Number of failed SQL queries executed on the Db2 database. | Count |
| db2.db.internal.commits | Number of internal commits performed on the Db2 database. | Count |
| db2.db.commits.rate | Rate of commits on the Db2 database. | Count |
| db2.db.rollbacks.rate | Rate of rollbacks on the Db2 database. | Count |
| db2.db.deadlocks | Number of deadlocks encountered in the Db2 database. | Count |
| db2.db.ddl.sql.queries.rate | Rate of DDL (Data Definition Language) SQL queries on the database. | Count |
| db2.db.internal.rollbacks | Number of internal rollbacks performed on the Db2 database. | Count |
| db2.db.package.cache.inserts.rate | Rate of inserts into the Db2 package cache. | Count |
| db2.db.package.cache.lookups.rate | Rate of lookups into the Db2 package cache. | Count |
| db2.db.active.hash.joins.rate | Rate of active hash joins on the Db2 database. | Count |
| db2.db.sorts.rate | Rate of sorts performed on the Db2 database. | Count |
| db2.db.hash.joins.rate | Rate of hash joins on the Db2 database. | Count |
| db2.db.sort.overflows | Number of sort overflows in the Db2 database. | Count |
| db2.db.active.olap.functions | Number of active OLAP (Online Analytical Processing) functions. | Count |
| db2.db.lock.list.memory.bytes | Amount of memory used by the lock list in the Db2 database. | Count |
| db2.db.active.sorts | Number of active sorts in the Db2 database. | Count |
| db2.db.connected.applications | Number of currently connected applications to the Db2 database. | Count |
| db2.db.executing.applications | Number of currently executing applications in the Db2 database. | Count |
| db2.db.connections | Number of active connections to the Db2 database. | Count |
| db2.db.secondary.connections | Number of active secondary connections to the Db2 database. | Count |
| db2.db.package.cache.overflows | Number of overflows in the Db2 package cache. | Count |
| db2.db.locks | Number of locks in the Db2 database. | Count |
| db2.db.direct.reads.rate | Rate of direct reads from the Db2 database. | Count |
| db2.db.direct.reads.requests.rate | Rate of requests for direct reads from the Db2 database. | Count |
| db2.db.direct.writes.rate | Rate of direct writes to the Db2 database. | Count |
| db2.db.direct.writes.requests.rate | Rate of requests for direct writes to the Db2 database. | Count |
| db2.db.lock.waiters | Number of lock waiters in the Db2 database. | Count |
| db2.db.lock.escalations | Number of lock escalations in the Db2 database. | Count |
| db2.db.deleted.rows.rate | Rate of deleted rows from the Db2 database. | Count |
| db2.db.inserted.rows.rate | Rate of inserted rows into the Db2 database. | Count |
| db2.db.updated.rows.rate | Rate of updated rows in the Db2 database. | Count |
| db2.db.row.reads.rate | Rate of row reads from the Db2 database. | Count |
| db2.db.log.reads.rate | Rate of log reads from the Db2 database. | Count |
| db2.db.log.read.ops.rate | Rate of log read operations in the Db2 database. | Count |
| db2.db.log.write.ops.rate | Rate of log write operations in the Db2 database. | Count |
| db2.db.free.log.space.bytes | Amount of free log space in bytes in the Db2 database. | Count |
| db2.db.used.secondary.log.files | Number of used secondary log files in the Db2 database. | Count |
| db2.db.used.log.space.bytes | Amount of used log space in bytes in the Db2 database. | Count |
| db2.db.exclusive.lock.escalations | Number of exclusive lock escalations in the Db2 database. | Count |
| db2.db.lock.waits | Number of lock waits in the Db2 database. | Count |
| db2.db.lock.timeouts | Number of lock timeouts in the Db2 database. | Count |
| db2.db.catalog.cache.inserts.rate | Rate of inserts into the Db2 catalog cache. | Count |
| db2.db.catalog.cache.lookups.rate | Rate of lookups into the Db2 catalog cache. | Count |
| db2.db.catalog.cache.overflows | Number of overflows in the Db2 database catalog cache. | Count |
| db2.db.successful.sql.queries | Number of successful SQL queries executed in the Db2 database. | Count |
| db2.db.unit.works | Number of unit works in the Db2 database. | Count |
| db2.db.package.cache.hit.ratio.percent | Percentage of hits in the Db2 package cache. | Count |
| db2.db.lock.waiting.percent | Percentage of time spent waiting for locks in the Db2 database. | Count |
| db2.db.sort.overflow.used.percent | Percentage of sort overflows used in the Db2 database. | Count |
| db2.db.log.space.bytes | Amount of log space in bytes in the Db2 database. | Count |
| db2.db.log.space.used.percent | Percentage of used log space in the Db2 database. | Count |
| db2.db.catalog.cache.hit.ratio.percent | Percentage of hits in the Db2 catalog cache. | Count |
| db2.db.lock.wait.time.ms | Time spent waiting for locks in the Db2 database (in milliseconds). | Count |
| db2.db.direct.read.time.ms | Time taken for direct reads in the Db2 database (in milliseconds). | Count |
| db2.db.sort.time.ms | Time taken for sorting in the Db2 database (in milliseconds). | Count |
| db2.db.index.page.hit.ratio.percent | Percentage of hits in the Db2 index page cache. | Count |
| db2.db.data.page.hit.ratio.percent | Percentage of hits in the Db2 data page cache. | Count |
| db2.db.database.buffer.pool.hit.ratio.percent | Percentage of hits in the Db2 database buffer pool. | Count |
| db2.db.direct.write.time.ms | Time taken for direct writes in the Db2 database (in milliseconds). | Count |
| db2.db.direct.write.request.time.ms | Time taken for direct write requests in the Db2 database (in milliseconds). | Count |
| db2.db.direct.read.request.time.ms | Time taken for direct read requests in the Db2 database (in milliseconds). | Count |
| db2.db.select.sql.queries.rate | Rate of select SQL queries executed in the Db2 database. | Count |
| db2.db.log.writes.rate | Rate of log writes in the Db2 database. | Count |