PH67607: ENHANCEMENTS, USABILITY IMPROVEMENTS, AND BUG FIXES FOR IBM DB2 SQL TUNING SERVICES.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SQL Tuning Services Enhancements, Usability Improvements, and
  Bug Fixes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All SQL Tuning service users                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancements:                           *
  *                      1.Comprehensive support for tuning      *
  *                      without a profile, including for all    *
  *                      workload tuning features.               *
  *                      2.The ability for a user to have        *
  *                      multiple tokens active concurrently     *
  *                      to connect to the tuning server from    *
  *                      any clients that they might be using    *
  *                      by configuring the num_of_tokens        *
  *                      parameter.                              *
  *                      3.Support for using a virtual keyring   *
  *                      to connect to a Db2 secure port when a  *
  *                      Db2 truststore has not been specified   *
  *                      in the tmsservice.config file.          *
  *                      4.Improved concurrency across Index     *
  *                      Advisor, Index Impact Analyzer, and     *
  *                      Virtual Index Analysis tuning actions.  *
  *                      5.Support for read/write isolation on   *
  *                      the USS installation path by setting    *
  *                      the WLP_OUTPUT_DIR configuration        *
  *                      parameter.                              *
  *                      6.The prune API                         *
  *                      (/tuningservice/v1/jobs/prune) does     *
  *                      not return results in cases where no    *
  *                      jobs match the specified criteria.      *
  *                      7.Support for password masking in       *
  *                      output logs.                            *
  *                                                              *
  *                      Fixes:                                  *
  *                      1.Explain records are now retrieved     *
  *                      when working with data sharing groups.  *
  *                      2.Corrected a situation in which Index  *
  *                      Advisor recommended duplicate indexes   *
  *                      on expressions.                         *
  *                      3.Index Advisor no longer fails when    *
  *                      running with SQL Annotator for a query  *
  *                      that contains special characters.       *
  *                      4.Parameters of the SQL Capture API     *
  *                      are now validated.                      *
  *                      5.Corrected a situation in which Query  *
  *                      Rewrite Advisor became non-responsive.  *
  ****************************************************************
  Enhancements:
  1.Comprehensive support for tuning
  without a profile, including for all
  workload tuning features.
  2.The ability for a user to have
  multiple tokens active concurrently
  to connect to the tuning server from
  any clients that they might be using
  by configuring the num_of_tokens
  parameter.
  3.Support for using a virtual keyring
  to connect to a Db2 secure port when a
  Db2 truststore has not been specified
  in the tmsservice.config file.
  4.Improved concurrency across Index
  Advisor, Index Impact Analyzer, and
  Virtual Index Analysis tuning actions.
  5.Support for read/write isolation on
  the USS installation path by setting
  the WLP_OUTPUT_DIR configuration
  parameter.
  6.The prune API
  (/tuningservice/v1/jobs/prune) does
  not return results in cases where no
  jobs match the specified criteria.
  7.Support for password masking in
  output logs.
  
  Fixes:
  1.Explain records are now retrieved
  when working with data sharing groups.
  2.Corrected a situation in which Index
  Advisor recommended duplicate indexes
  on expressions.
  3.Index Advisor no longer fails when
  running with SQL Annotator for a query
  that contains special characters.
  4.Parameters of the SQL Capture API
  are now validated.
  5.Corrected a situation in which Query
  Rewrite Advisor became non-responsive.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO06084

Modules/Macros

• DSN5DTMS DSN5INSH
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UO06084

     UP25/12/19 P F512  

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.