Software
DB2 Plug-in for
Oracle Enterprise Manager
Monitor IBM Db2 environments from Oracle Enterprise Manager. Daily configuration snapshots with history and compare, curated Warning and Critical thresholds enabled out of the box, and three compliance standards, with support for local or remote agents.
43
Metric Groups
11.5 & 12.1
Db2 Versions
13.5 & 24ai
Oracle EM Supported
12
Compliance Rules
3 Native Console Pages
Home, Analysis, and Performance render natively inside Oracle Enterprise Manager. Backup history, SQL workload trends, and the full HADR column set are collected as metric groups under All Metrics in this release.
Home
Seven-day availability plus a configuration summary (instance, database, status, path, capacity, size, and connections), a connections chart, lock and deadlock activity, an HADR status table, and open incidents.
Analysis
Live lock contention with requester and holder detail, Top Waits by Blocked Application with a Kill Application button, and Top Waits by Blocking Application.
Performance
Real-time charts for buffer-pool I/O, catalog and package cache hit ratios, transaction-log I/O, direct I/O, SQL activity rate, and space utilization and lock waits, with EM metric history behind each one.
Enterprise-Grade Capabilities
Everything listed here ships in the current release.
SQL Workload Trends
Periodic top-SQL snapshots by CPU time and by execution count, with per-statement trends from the last hour to the last month. Keyed by statement-ID hash; statement text is not collected in this release.
HADR Monitoring
Role, state, sync mode, connection status, heartbeats, and log positions for every HADR pair, collected every 45 minutes, with a summary table on Home. A takeover-readiness composite, backed by log-gap and replay-lag columns, alerts when the standby could not take over right now, and a connection-status alert fires on CONGESTED or DISCONNECTED.
Lock-Wait Analysis & Kill Application
The Analysis page breaks lock contention down by blocked and blocking application. Select the blocker and press Kill Application; a confirmation dialog appears before anything runs, and you never write the command yourself. The job needs a local agent and host credentials.
Backup History & Freshness Alerting
Backup age warns after one day without a backup and goes critical after three. The DB_History metric group reads backup, restore, and load operations straight from SYSIBMADM.DB_HISTORY, and any failed operation raises a critical alert immediately.
Tablespace Growth Forecasting
Per-tablespace snapshots feed a growth rate and days-to-full projection, with a warning under 30 days, a critical under 7, and a resize-failed alert.
Least-Privilege & TLS-First Security
The monitoring user needs CONNECT and SQLADM, nothing more: it can see how the database behaves and cannot read a row of table data. TLS with client-truststore validation and DRDA AES-256 encryption are first-class target properties, and the JDBC driver ships bundled.
Compliance
12 rules across three standards: configuration best practices, audit posture, and version lifecycle. All three evaluate under the same least-privilege monitoring user, with no rule authoring.
Broad Compatibility
IBM Db2 LUW
12.1 (certified) · 11.5 (supported; live certification in progress) · 9.1–10.5 not supported
Oracle Enterprise Manager
Cloud Control 13.5 and 24ai (24.1)
Management Agent
Linux x86-64 or Windows x86-64, local to the Db2 host or remote. Metric collection works either way; the five administrative jobs and diagnostic-log monitoring need a local agent. Amazon RDS for Db2 is documentation-verified, not yet lab-certified.
How It Works
Deploy the Plug-in
Stage the plug-in's OPAR in Oracle Enterprise Manager and install it on the OMS and Management Agents that will monitor Db2.
Configure Targets
Add each Db2 database as an IBM DB2 Database (Beta) target with JDBC connection details, credentials, and your beta license key. The JDBC driver is bundled, so there is nothing to stage.
Start Monitoring
Open the three console pages inside Oracle EM. Curated thresholds, backup-freshness alerts, and HADR alerts start on their own, and the six job types, including Kill Application, run from a local agent.
Ready to Unify Your Database Monitoring?
See how the DB2 Plug-in for Oracle Enterprise Manager can simplify your operations.