Performance enhancements

The performance of the Db2 data server is enhanced for the 12.1 release, providing a robust and highly reliable data server solution for any size of organization.

The following table lists performance enhancements that have been added to Db2® 12.1:
Table 1. Performance enhancements in 12.1
Enhancement Description
DB2_USE_FAST_LOG_PREALLOCATION The DB2_USE_FAST_LOG_PREALLOCATION performance variable allows the fast preallocation file system feature to reserve space for log files, so large log files can be created or altered faster. This variable is now ON by default.
AI Query Optimizer. The AI Query Optimizer now provides more accurate statistics for better planning.
ADMIN_MOVE_TABLE performance enhancements. The ADMIN_MOVE_TABLE stored procedure is enhanced to provide better performance for row to columnar conversion through parallel and vectorized insert operations.
Native Cloud Object Performance improvements. Db2 native cloud objects are enhanced to provide better performance for large environments.
Improved performance of backup operations. Performance during backup operations is improved through the following enhancements:
  • Intra-table-space Parallelism (ITP) enables Db2 to use multiple threads when backing up each table space. In cases where one or more table spaces are much larger than the others, the overall elapsed time to run the backup operation is substantially reduced.
  • Zlib compression provides hardware accelerated compression when running backup operations on Power Linux platforms.
Crash recovery. Recovery time is now reduced in the unlikely event of a system crash.
UPDATE and JOIN operations. Compact varchar enhancements now provide better performance of UPDATE and JOIN operations.