What's new in Db2 11

Db2 11 for z/OS® (also referred to as Db2 11 or Db2) delivers key innovations that reduce your total cost of ownership. Db2 11 provides enhanced analytics and increased availability, reliability, and security for your business-critical information. In addition, Db2 11 offers improvements that make installation and migration simpler and faster.

End of support (EOS): Db2 11 reached EOS on March 31, 2021. The online product documentation is provided as-is for clients with extended service contracts. For more information, see End of support (March 31, 2021).

Performance improvements

Performance improvements in Db2 11 focus on optimizing query processing and reducing CPU processing time without causing significant administration or application changes. However, Db2 11 also offers a balanced approach to performance improvements across all types of workloads, whether your workloads are for online transaction processing (OLTP), batch, or utilities.

For more information about performance improvements, see Performance.

Expanded RBA and LRSN log records

In Db2 11, the relative byte address (RBA) and log record sequence number (LRSN) log records are expanded from basic 6-byte format to extended 10-byte format. You also can convert the RBA and LRSN to extended 10-byte format to avoid reaching the logging limits. Extending the RBA and LRSN to 10-byte format helps to avoid wrapping of the RBA and LRSN values, which can cause system problems. In addition, the increased precision of the 10-byte format for the LRSN provides performance improvements for data sharing environments.

For more information about this enhancement, see Expanded RBA and LRSN log records.

Availability enhancements

In Db2 11 you can alter the limit keys for a partitioned table space without impacting the availability of the data. When you change the limit key values, the data remains available and applications can continue to access the data.

For more information about this and other availability improvements, see Improved availability when altering limit keys and Availability.

Archive transparency

In Db2 11, Db2 can automatically insert rows that are deleted from one table into a separate table that is called an archive table. Archive tables provide the following benefits:

  • Db2 can manage historical data for you. You do not have to manually move data to a separate table.
  • Because rows that are infrequently accessed are stored in a separate table, you can potentially improve the performance of queries against the archive-enabled table.
  • You can modify queries to include or exclude archive table data without having to change the SQL statement and prepare the application again. Instead, you can control the scope of the query with a global variable.
  • You can store archive tables on a lower-cost device to reduce operating costs.

For more information about archive tables, see Support for archive tables.

For information about other ease of use enhancements in Db2 11, see Ease of use.

Security and regulatory compliance

With key enhancements in Db2 11, Db2 for z/OS and IBM® Z continue to lead the industry in security and auditing.

For more information about security enhancements, see Security and regulatory compliance.

New application features

In Db2 11, expanded support for SQL, XML, and temporal tables results in improved application performance.

For more information about expanded application features, see New application features.

Simpler, faster migration

In Db2 11, simpler, faster migration results in a faster return on your investment. This version of Db2 for z/OS provides enhancements to the Db2 installation CLIST, ISPF panels, and jobs, and provides new installation verification procedures (IVPs). Also, a new feature helps to streamline the migration process by allowing an application with incompatible SQL or XML to continue running on Db2 11 without requiring code changes. You no longer need to wait for application changes to be planned and delivered for your business to realize the benefits of Db2 11.

For more information about migration enhancements, see Migration.