Software
DB2 Plug-in for
Oracle Enterprise Manager
Comprehensive monitoring of IBM Db2 environments, inside Oracle Enterprise Manager. Configuration tracking, threshold-based alerts, and out-of-the-box reports — including support for remote agents.
52
Metrics Monitored
11.5 & 12.1
Db2 Versions
13.5 & 24.1
OEM Supported
3 Purpose-Built Pages
Native dashboards rendered inside Oracle Enterprise Manager.
Home
Target status, Db2 version, host, and HADR role/state/connect status at a glance. Start/Stop buttons for the Db2 instance and Quiesce/Unquiesce buttons for the database. Applications ranked by CPU, rows read/written, and SQL statement counts, with cache-ratio and tablespace-utilization charts.
Analysis
A Top SQL Statements panel, switchable between CPU Time and Execution Count over day/week/month, with per-statement trend charts. Four Lock Waits views — by blocking application, blocked application, table, and all-waits — with one-click Kill Application from the blocked-app view.
Performance
Historical trends across nine KPIs in three groups with Day/Week/Month selector — Cache & Connection (current connections, catalog and package cache hit ratios), Storage & I/O (utilization, reads/sec, writes/sec), and SQL Execution (lock wait time, sort heap utilization, deadlocks/sec).
Enterprise-Grade Capabilities
Every capability here ships in the current release, verifiable against the plug-in source.
Top-SQL Analysis
Rank the most-executed and most CPU-intensive SQL statements across your Db2 instance over the last day, week, or month. Drill directly into the offending workload from the Analysis page.
HADR Monitoring
Watch every Db2 HADR pair from OEM. Replication role, HADR state, sync mode, connection status, heartbeat, and log positions are collected every 45 minutes. Alerts fire automatically on state changes, sync-mode changes, and connection-status changes.
One-Click Kill Application
Identify blocked applications and their blockers on the Analysis page. Select the blocker and press Kill Application to terminate it — no CLI, no manual SQL, with a confirmation dialog before anything runs.
Backup-Freshness Alerting
The DB_Backup metric tracks last backup timestamp and days since last backup, collected every two hours. A critical alert fires by default at 7 days since last backup — so a silently-skipped backup job can't accumulate into a disaster.
Lock-Wait Analysis
Four complementary views of lock waits, switched from a single dropdown: by blocking application, by blocked application, by table, and an all-waits breakdown with lock name, type, schema, table, requester, and holder.
Remote-Agent Monitoring
The plug-in supports remote monitoring — the Management Agent does not need to be installed on the same machine as the Db2 database.
Broad Compatibility
IBM Db2
11.5 · 12.1
Oracle Enterprise Manager
Cloud Control 13.5 and later · Cloud Control 24.1 and later
Operating Systems
All platforms where the Oracle Management Agent is supported — runs locally with Db2 or on a separate remote host.
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
Place db2jcc4.jar in the agent plug-in JDBC directory and add each Db2 database as an ibm_db2_database target with JDBC connection details and credentials.
Start Monitoring
Open the Home, Analysis, and Performance pages inside OEM. Receive backup-freshness and HADR alerts. Run any of the five one-click admin jobs — Start, Stop, Quiesce, Unquiesce, and Kill Application.
Ready to Unify Your Database Monitoring?
See how the DB2 Plug-in for Oracle Enterprise Manager can simplify your operations.