This topic describes new and changed SQL Tuning Services functions and identifies the APARs that deliver these functions.
| APAR |
Date |
Description |
| PH60806 |
June 2024 |
- A new
single_query_tuning_actions API that provides the following capabilities:
- Support for invoking a subset of the SQL Tuning Services APIs without creating or specifying a tuning profile
- Support for invoking multiple tuning actions simultaneously on a single query
- The use of multi-factor authentication (MFA) to tune SQL
- Support for Java 17.
- The addition of a
'host' parameter to the sqlcapture/dataset API to support capturing SQL from a data set in environments where the z/OSMF host is not the same as the Db2® host.
- An enhancement that enables Index Advisor to tune a query that has a
'fetch first ? rows only' clause.
- An improved error message that is issued when a tuning profile is created.
- A fix for an issue in which Index Advisor and Workload Index Advisor incorrectly return report card=-1.
|
| PH59959 |
March 2024 |
- Support for using the following security mechanisms for tuning connection profiles:
- 7 - User ID and encrypted password
- 9 - Encrypted user ID and encrypted password
- 18 - Certificate authentication
- Support for sorting workloads by their creation time in descending order.
- Support for sorting jobs by their start time in descending order.
- An enhancement to the installation script in which, if you are using key ring for Liberty SSL, you are no longer prompted for a key ring password.
- An enhancement to the installation script that adds the sslTrustStoreType and sslTrustStorePassword parameters to the tmsservice.config configuration file.
- Miscellaneous fixes. See the APAR for details.
|
| PH58058 |
January 2024 |
- A new repoDBCredReset.sh script, which enables an administrator to reset the repository database connection logon credentials.
- An enhancement to the
GET/DELETE jobs API that adds more filters.
- An enhancement to the
GET connection profile API that adds more properties.
- The removal of the dependency on db2jcc_license_cisuz.jar.
- Miscellaneous fixes. See the APAR for details.
|
| PH56970 |
October 2023 |
- Support for the following new SQL tuning features:
- Workload Environment Capture
- Workload Analytics Acceleration Advisor
- Workload Candidate Acceleration Analyzer
- Support for TLS 1.3.
- To support Db2 13 for z/OS®, an enhancement to the SQL capture API that supports the new value of S in the VALID column of the SYSPACKAGE and SYSPACKCOPY catalog tables.
- An enhancement to the SQL Capture and Index Impact Advisor APIs for customizing the versions of bound packages.
- An enhancement to the Index Impact Analyzer API for adding a job description to specify the source job.
- Miscellaneous fixes. See the APAR for details.
|
| PH55158 |
July 2023 |
- Support for the following new SQL tuning features:
- Single query and Workload Virtual Index Analysis API
- Single query and Workload Impact Analysis API
- Workload Refine API
- Workload Explain failure reason API
- An enhancement to the installation process that enables you to specify the repository database after the server is installed and started.
- Sample JCL to upgrade the repository database.
- A new
set_repo API
- An enhancement to the
List workloads API to include more information in a summary report.
- A change to the
CreateRepo API to support the creation of only a new repository database.
- Miscellaneous fixes. See the APAR for details.
|
| PH53536 |
May 2023 |
- The new Capture SQL from z/OS data set API.
- An enhancement that updates the value of Explain_Status for each statement in a workload.
- Enhancements to simplify the configuration script.
- An enhancement that reduces idle CPU consumption.
- Enhancements to sample JCL to remove dependency on SYSPROC.DSNAHVPM and eliminate SYSADM authority.
- Miscellaneous fixes. See the APAR for details.
|