What's new and changed in Db2

Db2® updates can include new features, bug fixes, and security updates. Updates are listed in reverse chronological order so that the latest release is at the beginning of the topic.

You can see a list of the new features for the platform and all of the services at What's new in IBM® Cloud Pak for Data.

Installing or upgrading Db2

Ready to install or upgrade Db2?

Related documentation:

Refresh 8 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in April 2022.

Operand version: 4.0.10

The 4.0.10 release of Db2 includes the following features and updates:

SSL certificate extended
The SSL endpoint certificate that is used by Db2 now has an expiration of one year and 30 days. Previously the certificate expired after one month. If you are installing Db2 for the first time, the new certificate is automatically installed when you deploy the Db2 service. This feature is only available for new deployments.

Version 4.0.10 of the Db2 service includes various fixes.

Refresh 7 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in March 2022.

Operand version: 4.0.9

Version 4.0.9 of the Db2 service includes various fixes.

Refresh 6 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in February 2022.

Operand version: 4.0.8

The 4.0.8 release of Db2 includes the following features and updates:

Save space by compressing your backup images
When you install Db2, you can specify that the service enable compression of backup images. Backup compression can help reduce the storage cost in your database environment. If you want to compress backup images, you must specify enableBackupCompression: Yes in the Db2 custom resource.

Version 4.0.8 of the Db2 service includes various fixes.

Refresh 5 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in January 2022.

Operand version: 4.0.7

Version 4.0.7 of the Db2 service includes various fixes.

Security fixes
This release includes fixes for the following security issues:

CVE-2021-45046, CVE-2021-45105

Refresh 4 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in December 2021.

Operand version: 4.0.6

The 4.0.6 release of Db2 includes the following features and updates:

High-speed data replication
High-speed data replication capability for Db2 was announced and is available in Cloud Pak for Data 4.0.4 and 4.0.3. Replication supports continuous availability, data locality, and compliance and regulatory requirements. The replication feature in Db2 provides the ability to fail over and fallback during planned and unplanned outages, with low latency and high-volume throughput. You can protect applications for continuous availability by replicating transactions on the tables that are used by these applications. You can also keep active copies of data in proximity to users, for example allowing east coast clients to access data from an east coast data center, and west coast clients from a west coast data center. For details, see Replication.
New version of Db2
This release of the Db2 service runs Db2 Version 11.5.7.0.

Version 4.0.6 of the Db2 service includes various fixes.

Refresh 3 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in November 2021.

Operand version: 4.0.5

The 4.0.5 release of Db2 includes the following features and updates:

Support for Power® 10 hardware
You can now install Db2 on Red Hat® OpenShift® Container Platform Version 4.8 clusters running on Power 10 hardware. However, the service does not take advantage of Power 10 optimizations.

Version 4.0.5 of the Db2 service includes various fixes.

Refresh 2 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in October 2021.

Operand version: 4.0.3

The 4.0.3 release of Db2 includes the following features and updates:
Support for gathering diagnostic data
When you request support from IBM for the Db2 service, you can use the Support > Diagnostics feature to collect the diagnostic logs for the service. Ensure that you select Db2 when you create a new diagnostic job. For details, see Gathering diagnostic information.
Separate storage for temporary table spaces
When you deploy the Db2 service, you can now specify a separate storage area for temporary table spaces on the Db2 pod to reduce I/O bottlenecks and improve performance.
Version 4.0.3 of the Db2 service includes various fixes.

Refresh 1 of Cloud Pak for Data Version 4.0

A new version of Db2 was released in July 2021.

Operand version: 4.0.1

The 4.0.1 release of Db2 includes the following features and updates:
Support for upgrade
You can now upgrade Db2 from the following Cloud Pak for Data releases:u
  • Cloud Pak for Data Version 3.5.x
  • Cloud Pak for Data Version 4.0.x
Separate storage for log files
When you deploy the Db2 service, you can now specify a separate storage area for database transaction logs on the Db2 pod to reduce I/O bottlenecks and improve performance.

Version 4.0.1 of the Db2 service includes various fixes.

Initial release of Cloud Pak for Data Version 4.0

Version 4.0.0 of the Db2 service includes the following features and updates:
Support for multiple HADR standbys
The Db2 service now supports multiple standby databases for the High Availability Disaster Recovery (HADR) feature. By creating multiple standbys, you can have your data in more than two sites, which provides improved data protection with a single technology. You can now use HADR to achieve:
  • High availability objectives
  • Disaster recovery objectives, which previously required another technology

For details, see Using multiple HADR standby databases.

Snapshot backup and restore
Db2 supports new backup and restore method that is based on the OpenShift APIs for Data Protection. This method enables snapshot backup and restore for both Kubernetes resources and storage data. Snapshot backups have significant advantages over traditional backups; snapshot backups:
  • Are completed quickly, regardless of database size
  • Allow for fast recovery
  • Do not affect many database operations, except momentarily pausing operations that perform writes.

For details, see Performing a snapshot backup.