Performance tuning enhancements
Db2 11.5.9 provides better control over the display of EXPLAIN information when you generate query access plans.
Attention: This mod pack release is currently available for
the following Db2 products:
- Db2 Distributed (on-premises)
- The single container deployment of Db2 Warehouse.
- The container micro-service deployment of Db2 on Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
- Db2 for cloud service providers
- Db2 on Cloud
- Db2 Warehouse on Cloud
The following table lists performance tuning enhancements that are included in Db2
11.5.9:
| Enhancement | Description |
|---|---|
| Easily format how explain information appears for query access plans. | With the release of Db2
11.5.9,
you can run the EXPLAIN_FORMAT stored procedure to format explain table information that is generated when
you explain an SQL statement. The EXPLAIN_FORMAT stored procedure formats the explain information
consistent with db2exfmt and stores the result in a new explain table column. For
more information about the db2exfmt command, see Understanding db2exfmt
information. |