PH63509: SQL TUNING SERVICES INTERNAL ENHANCEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SQL Tuning Services Internal Enhancement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 for z/OS SQL Tuning Services users   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Defects fixed:                          *
  *                      1. The installation script no longer    *
  *                      prompts for a password when the         *
  *                      credential type is PassTicket.          *
  *                      2. The qualifier for packages in the    *
  *                      DSN5NBND and DSN5NDRP bind jobs has     *
  *                      been corrected.                         *
  *                      3. The jvm.options file has been        *
  *                      updated with language options that      *
  *                      prevent extraneous warning messages     *
  *                      to be written to the log.               *
  *                      4. An issue has been corrected that     *
  *                      resulted in the jvm.options file being  *
  *                      corrupted after installation.           *
  *                      5.Capture Query Environment jobs are    *
  *                      now marked as obsolete when the         *
  *                      output file has been deleted.           *
  ****************************************************************
  Defects fixed:
  1. The installation script no longer
  prompts for a password when the
  credential type is PassTicket.
  2. The qualifier for packages in the
  DSN5NBND and DSN5NDRP bind jobs has
  been corrected.
  3. The jvm.options file has been
  updated with language options that
  prevent extraneous warning messages
  to be written to the log.
  4. An issue has been corrected that
  resulted in the jvm.options file being
  corrupted after installation.
  5.Capture Query Environment jobs are
  now marked as obsolete when the
  output file has been deleted.
  

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:

  UI99099

Modules/Macros

• DSN5DTMS DSN5INSH DSN5NBND DSN5NDRP DSN5STRT
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UI99099

     UP24/11/21 P F411  

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.