Highlights of Db2 11.5.4

IBM® Db2 11.5.4 offers database efficiency, simplicity, and reliability in the form of new features and enhancements that address a wide variety of business requirements. Comprehensive enterprise security, simplified installation and deployment, better usability and adoption, a streamlined upgrade process, and enhancements to large databases.

Attention: This mod pack release is currently available for the following Db2 products:

Improved high availability with Advanced Log Space Management (ALSM)

Db2 can now reduce the impact of transaction log full conditions on application failure with Advanced Log Space Management (ALSM). Using ALSM, the Db2 transaction manager identifies long running transactions that could be causing transaction log full conditions. ALSM then takes the transaction log data from the active log files and copies it into separate extraction log files dedicated for the transaction. This allows the original active log files to be removed to free up disk space, so that new active log files can be created. For more information, see Advanced Log Space Management.

New Db2 support for the Red Hat OpenShift Container Platform

Db2 can now be deployed as a container micro-service in a Red Hat® OpenShift® cluster. This separation of operational components into separate containers helps improve reliability while reducing platform dependence. For more information, see Db2 containerized deployments.

New supported operating system versions

Db2 V11.5.4 runs on the following operating systems:
  • Red Hat Enterprise Linux (RHEL) Version 8.1
  • SUSE Linux Enterprise Server (SLES) Version 15 SP1
  • Windows 2019
Note: Support for these operating systems is available for non-pureScale configurations only.

For information on the latest operating system versions supported by Db2, see System requirements for IBM Db2 for Linux, UNIX, and Windows.

New Adaptive Workload Manager

Db2 Analytics databases can now enable and use the Adaptive Workload Manager, providing increased flexibility, stability, and simplified configuration and tuning. For more information, see Adaptive workload manager.

New In-database machine learning

With in-database machine learning, you can build, evaluate, and deploy a machine learning model without moving data from your Db2® database. For more information, see In-database machine learning.

New REST API container

You can configure Db2 to allow developers to create Representational State Transfer (REST) endpoints. These REST endpoints are each associated with a single SQL statement. Authenticated users of web, mobile, or cloud applications can then use these REST endpoints to interact with Db2 from any REST HTTP client without having to install any drivers. For more information, see REST endpoints.

A technical preview: Pacemaker cluster manager

As a potential replacement for IBM®'s cluster manager, Tivoli® System Automation for Multiplatforms (SA MP), Db2 now presents Pacemaker as a cloud-friendly cluster management alternative for deploying High Availability and Disaster Recovery (HADR) Db2 solutions. For more information, see Integrated solution using Pacemaker.

A technical preview: IBM Db2 Graph

IBM Db2 Graph enables real time graph analytics in Db2. For more information, see Technology preview for IBM Db2 Graph.

A technical preview: Machine Learning Optimizer

The Machine Learning Optimizer enables you to influence the Db2 optimizer cardinality estimates during query compilation plan selection. This technology preview is currently intended for non-production environments. For more information, see Machine Learning Optimizer Technology Preview for Db2 11.5.4.