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.

Attention: The Db2 12.1 release is currently available for the following Db2® products:

Db2 Distributed (on-premises)
The container micro-service deployments of Db2 and Db2 Warehouse for Kubernetes-based clusters, which includes Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).

The following table lists performance enhancements that have been added to Db2 12.1:

Table 1. Performance enhancements in 12.1
Enhancement	Description
Intra-table-space Parallelism (ITP) for backup operations	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.
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.