PH65492: SQL TUNING SERVICE INTERNAL ENHANCEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SQL Tuning Service Internal Enhancement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All SQL Tuning service users                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancements:                           *
  *                      - Support for storing private keys in   *
  *                      ICSF                                    *
  *                      - Support for the use of one-time       *
  *                      tokens for Index Impact Analyzer and    *
  *                      Virtual Index Analyzer jobs             *
  *                      - Support for running SQL Capture jobs  *
  *                      without specifying a tuning profile     *
  *                      - Capture Query Environment job status  *
  *                      now changes to Obsolete when the        *
  *                      associated zip file is deleted          *
  *                                                              *
  *                      Bug fixes:                              *
  *                      - Corrected information for the SQL     *
  *                      Capture API in Swagger documentation    *
  *                      - The existence of the UDF for the SQL  *
  *                      Tuning Services trial license is now    *
  *                      checked to eliminate SQLCODE -440       *
  *                      being issued                            *
  *                      - The context rule URL is redirected    *
  *                      to the Swagger documentation            *
  *                      - The group_member parameter has been   *
  *                      removed from an internal query to fix   *
  *                      an EXPLAIN issue in data sharing        *
  *                      environments                            *
  *                      - An error message is now issued when   *
  *                      a Capture Query Environment job does    *
  *                      not complete successfully due to a      *
  *                      problem with an associated stored       *
  *                      procedure                               *
  *                      - Fixed an issue that caused the SQL    *
  *                      Tuning Services started task to end     *
  *                      after 10 minutes when the repository    *
  *                      database is configured for PassTickets  *
  *                      - Fixed an issue in which running the   *
  *                      tmsservice.sh script in an upgrade      *
  *                      scenario removes the license jar file   *
  *                      - Fixed a problem with -DTMS_HOME in    *
  *                      the redoDBCredReset.sh script           *
  *                      - Fix an issue that caused TMSFM0008E   *
  *                      to be issued when the Single Query      *
  *                      Tuning Actions API is used              *
  ****************************************************************
  Enhancements:
  - Support for storing private keys in ICSF
  - Support for the use of one-time tokens for Index Impact
  Analyzer and Virtual Index Analyzer jobs
  - Support for running SQL Capture jobs without specifying a
  tuning profile
  - Capture Query Environment job status now changes to Obsolete
  when the associated zip file is deleted
  Bug fixes:
  - Corrected information for the SQL Capture API in Swagger
  documentation
  - The existence of the UDF for the SQL Tuning Services trial
  license is now checked to eliminate SQLCODE -440 being issued
  - The context rule URL is redirected to the Swagger
  documentation (swagger-ui)
  - The group_member parameter has been removed from an internal
  query to fix an EXPLAIN issue in data sharing environments
  - An error message is now issued when a Capture Query
  Environment job does not complete successfully due to a problem
  with an associated stored procedure
  - Fixed an issue that caused the SQL Tuning Services started
  task to end after 10 minutes when the repository database is
  configured for PassTickets.
  - Fixed an issue in which running the tmsservice.sh script in
  an upgrade scenario removes the license jar file
  - Fixed a problem with -DTMS_HOME in the redoDBCredReset.sh
  script
  - Fix an issue that caused TMSFM0008E to be issued when the
  Single Query Tuning Actions API is used
  

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:

  UO02607

Modules/Macros

• DSN5DTMS DSN5INSH DSN5NBND DSN5NDRP DSN5NDTG DSN5REPO DSN5RGRT
  DSN5RTRP DSN5RTTG
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UO02607

     UP25/04/11 P F504  

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.