Changelog
This page lists what changed in each release of the IBM Db2 plug-in, most recent first. The general-availability (GA) plug-in is ip.em.xdb2, target type ip_db2_database. Its Enterprise Manager 24ai and Enterprise Manager 13.5 builds are versioned independently. The Open Beta history follows the GA releases, under Beta line.
24.1.1.0.0 (Enterprise Manager 24ai) / 13.5.2.0.0 (Enterprise Manager 13.5) — GA, 2026-10-12
The first general-availability release of ip.em.xdb2. One release, two builds with the same content: 24.1.1.0.0 installs on Enterprise Manager 24ai, 13.5.2.0.0 on Enterprise Manager 13.5. There is no earlier GA release to upgrade from. Moving from the Open Beta is a clean install — see Moving from the beta to GA. The full detail is on What’s new.
- Released the first general-availability version of the IBM Db2 plug-in for Oracle Enterprise Manager, for Db2 12.1 and 11.5. Moving from the Open Beta is a clean install, and the two can run side by side while you move over.
- Added monitoring for storage-path headroom, table maintenance, open and idle units of work, lock-list use, running utilities, and the SQL text behind each statement.
- Added a health overview on the Home page, links between the plug-in’s pages, a shared time window, and runbooks for the most common Db2 alerts.
- Added three administrative jobs (force an application, refresh table statistics, and take an online backup) that work on remotely monitored databases and run as a separate administrator account.
- Added compliance standards with seventeen rules, and HADR monitoring that follows the primary through a takeover and reports a standby as up.
- Renamed every administrative job type, and changed the default alert thresholds and collection intervals.
Known issue: after one failed text lookup, Top Statements keeps showing numbers without SQL text until the time window or the ranking changes — see What’s new.
Release files and SHA-256 checksums
| Enterprise Manager | File | SHA-256 |
|---|---|---|
| 24ai | 24.1.1.0.0_ip.em.xdb2_2000_0.opar |
afa4e2fbb38651f6cd3b699e9fd5551f51e39fa56839dff7f300281faa08aa35 |
| 13.5 | 13.5.2.0.0_ip.em.xdb2_2000_0.opar |
2cb83675ff82e21fd83b19c4f2294f1b8f7fd8747eefca15dd4afeb94568c7e9 |
Beta line
The Open Beta shipped as a separate plug-in, ip.em.xdbb (target type ip_db2_database_beta, shown as IBM DB2 Database (Beta)), versioned 24.1.9.N.0 for Enterprise Manager 24ai and 13.5.9.N.0 for Enterprise Manager 13.5. The beta line is closed: there are no further beta drops. These entries are kept for history.
24.1.9.9.0 (Enterprise Manager 24ai) / 13.5.9.4.0 (Enterprise Manager 13.5) — Open Beta
The last Open Beta drop, and the first to make the Enterprise Manager 13.5 build available alongside 24ai.
New in this release
- Full metric parity rebuilt on the clean
MON_GET_*surface: availability, roughly 14 performance groups, storage, and locking with by-table, by-blocked-application, and by-blocking-application roll-ups. No discontinuedSNAP_GET_*interface is used. - Backup, restore, and load history (
DB_History, fromSYSIBMADM.DB_HISTORY) with a failed-operation alert, beyond the existing age-only backup check. - SQL workload analytics (QAN v1): periodic top-SQL delta snapshots with per-statement CPU-time and execution-count trends, keyed by a statement-ID hash.
- Deep HADR monitoring: role, state, sync mode, connect status, heartbeats, and log positions, plus a takeover-readiness composite and a connection-status alert. See HADR monitoring.
- Tablespace growth trending and forecasting, with per-tablespace days-to-full projection and auto-resize tracking.
- Curated default Warning/Critical thresholds across the metric surface, in place of the
Not Definedthresholds a first release would otherwise ship. See Alerts and thresholds. - First-class TLS transport with client-truststore validation, and DRDA AES-256 encryption promoted to a first-class target property.
- A documented, certified least-privilege monitoring grant —
CONNECT+SQLADM, nothing more. See The monitoring role. - Compliance and advisor pack: configuration best-practices, version end-of-life advisory, and audit-posture standards. See Compliance standards.
- Three native console pages — Home, Analysis, Performance — with no dependency on a legacy report platform.
- Six administrative job types, including Purge Stale Plugin Cache. See Jobs.
- Amazon RDS for Db2 compatibility, documented. See Troubleshooting.
- Licensing enforcement. Every target now carries a Plugin Licence Key property and a
Licensemetric (status, days remaining, expiration, instances, customer), checked every 15 minutes and again whenever the key changes. While the status is anything butActive, every metric group except License, Response, and Version reportsCollection stopped by license status: <status>until a valid key is entered; availability keeps reporting, so the target stays Up. See Troubleshooting. - Query Analytics windows now say what they actually are: any window wider than roughly seven days is served from Enterprise Manager’s hourly rollup rather than raw samples, and is now labelled
(aggregated)so the count on screen is not read as a raw statement count.
Security
- The licence instance-count connection to the OMS validates the OMS certificate and hostname by default, and no longer retries in cleartext HTTP on a failed HTTPS attempt. Both behaviors are now opt-in, lab-only escape hatches rather than the default. See Troubleshooting.
Upgrade notes
- An OMS presenting a self-signed certificate that previously validated a limited-instance licence key’s count will now fail that check — this is the certificate-validation fix above taking effect, not a regression. See Troubleshooting for the fix.
- Run, or schedule, Purge Stale Plugin Cache after this and every future upgrade.
Also in this drop
- The DB Status threshold on the detailed response metric uses deviation semantics, matching the DB Monitoring condition: enter the healthy status (for example
ACTIVE) and the alert fires only when the database leaves it.
Earlier beta drops
These predate the beta guide and are recorded here for history only.
- 24.1.9.6.0 (2026-08-31) — First release cut through a repeatable release pipeline, producing an OPAR, a customer-verifiable
SHA256SUMS, and abuild-info.txtnaming the exact commit. Install and upgrade gates verified (Enterprise Manager 24ai only — the 13.5 line was not built for this drop). - 24.1.9.4.0 — Beta job types renamed so a beta install can no longer collide with a GA install on the same OMS.
- 24.1.9.3.0 — Internal build and test tooling refinements.
- 24.1.9.2.0 — The drop first documented for early access: feature-complete scope, verified live OMS deployment and Db2 12.1 collection on Enterprise Manager 24ai, and end-to-end licensing.
Related
- What’s new — the GA release in detail
- Moving from the beta to GA — for Open Beta users
- Install and upgrade — download, verify and install the release files
- IBM Db2 Plug-in — the documentation hub for every page in this guide