PH59959: SQL TUNING SERVICE ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SQL Tuning Service Enhancement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS SQL Tuning Services users                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * 1. Support for using a subset of the                         *
  *    SQL Tuning Services APIs without                          *
  *    creating or specifying a                                  *
  *    tuning connection profile                                 *
  * 2. 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                           *
  * 3. Support for sorting workloads by                          *
  *    their creation time                                       *
  *    in descending order                                       *
  * 4. Support for sorting jobs by their                         *
  *    start time in descending order                            *
  * 5. An enhancement to the installation                        *
  *    script in which, if you are using                         *
  *    keyring for Liberty SSL, you are                          *
  *    no longer prompted for a keyring                          *
  *    password                                                  *
  * 6. An enhancement to the installation                        *
  *    script that adds the                                      *
  *    sslTrustStoreType and                                     *
  *    sslTrustStorePassword parameters                          *
  *    to the tmsservice.config                                  *
  *    configuration file                                        *
  * 7. A fix that persists the appl_id for                       *
  *    passticket connection profiles                            *
  * 8. A security-related fix for                                *
  *    passwords that are stored in a                            *
  *    Java String object                                        *
  * 9. A fix for an encryption/decryption                        *
  *    issue related to the use of                               *
  *    IBMJCECCA                                                 *
  * 10.A fix for a missing quotation mark                        *
  *    character for tls1.2 and tls1.3                           *
  *    configurations in the server.xml                          *
  *    configuration file                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1. Support for using a subset of the SQL Tuning Services APIs
     without creating or specifying a tuning connection profile
  2. 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
  3. Support for sorting workloads by their creation time
     in descending order
  4. Support for sorting jobs by their start time
     in descending order
  5. An enhancement to the installation script in which, if you
     are using keyring for Liberty SSL, you are no longer
     prompted for a keyring password
  6. An enhancement to the installation script that adds the
     sslTrustStoreType and sslTrustStorePassword parameters to
     the tmsservice.config configuration file
  7. A fix that persists the appl_id for passticket connection
     profiles
  8. A security-related fix for passwords that are stored in a
     Java String object
  9. A fix for an encryption/decryption issue related to the use
     of IBMJCECCA
  10.A fix for a missing quotation mark character for tls1.2 and
     tls1.3 configurations in the server.xml configuration file
  

Problem conclusion

Temporary fix

Comments

• ×**** PE24/04/09 FIX IN ERROR. SEE APAR PH60806  FOR DESCRIPTION
  

APAR Information

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

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

  UI96033

Modules/Macros

• DSN5OWCN DSN5DTMS DSN5INSH
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UI96033

     UP24/03/30 P F403

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.