What's new in SQL Tuning Services

This topic describes new and changed SQL Tuning Services functions and identifies the APARs that deliver these functions.

APAR Date Description
PH63509 November 2024 Various enhancements to support IBM Db2 Query Workload Tuner for z/OS features and improvements to the SQL Tuning Services installation and configuration process.
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.