PH66651: 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:                           *
  *                      - The following APIs have been added    *
  *                      to support tuning workloads without     *
  *                      the use of a tuning profile and the     *
  *                      ability to specify a single-use MFA     *
  *                      token:                                  *
  *                      POST /tuningservice/v1/workloads_no_pr  *
  *                      ofile                                   *
  *                      POST /tuningservice/v1/wldexplain_no_p  *
  *                      rofile                                  *
  *                      POST /tuningservice/v1/workloads/{work  *
  *                      load_name}/refine_no_profile            *
  *                      GET /tuningservice/v1/workloads/{db2_c  *
  *                      onnection_info}/get_workload_list_no_p  *
  *                      rofile                                  *
  *                      - Updates to the installation script    *
  *                      enable you to configure a default       *
  *                      truststore for all Db2 subsystems       *
  *                      connected to the SQL Tuning Services    *
  *                      server.                                 *
  *                      - The SQL Capture from data set API     *
  *                      (tuningservice/v1/sqlcapture/dataset)   *
  *                      now supports PassTickets.               *
  *                      Fixes:                                  *
  *                      - In SQL Tuning Services integrations   *
  *                      with UMS in which the tuningApplicatio  *
  *                      nId is configured in the IZPDB2PM       *
  *                      PARMLIB, error message TMSSEC0005E:     *
  *                      Unauthorized Access! Check role failed  *
  *                      is no longer issued.                    *
  *                      - Index Advisor no longer recommends    *
  *                      ALTER operations on column expressions  *
  *                      . It now recommends only DROP or        *
  *                      CREATE operations.                      *
  *                      - A change was made to the              *
  *                      application.properties configuration    *
  *                      file to support rolling up log files.   *
  *                      - The following miscellaneous           *
  *                      installation enhancements have been     *
  *                      added:                                  *
  *                          - If a certificate or keyring for   *
  *                      the Liberty server is not specified     *
  *                      during installation, a default          *
  *                      self-signed certificate is used.        *
  *                          - If the path for the wlp_user_dir  *
  *                      folder contains white space, the white  *
  *                      space is removed.                       *
  ****************************************************************
  Enhancements:
  - The following APIs have been added to support tuning
  workloads without the use of a tuning profile and the ability
  to specify a single-use MFA token:
  POST /tuningservice/v1/workloads_no_profile
  POST /tuningservice/v1/wldexplain_no_profile
  POST /tuningservice/v1/workloads/{workload_name}/refine_no_prof
  ile
  GET /tuningservice/v1/workloads/{db2_connection_info}/get_workl
  oad_list_no_profile
  - Updates to the installation script enable you to configure a
  default truststore for all Db2 subsystems connected to the SQL
  Tuning Services server.
  - The SQL Capture from data set API (tuningservice/v1/sqlcaptur
  e/dataset) now supports PassTickets.
  Fixes:
  - In SQL Tuning Services integrations with UMS in which the
  tuningApplicationId is configured in the IZPDB2PM PARMLIB,
  error message TMSSEC0005E: Unauthorized Access! Check role
  failed is no longer issued.
  - Index Advisor no longer recommends ALTER operations on column
  expressions. It now recommends only DROP or CREATE operations.
  - A change was made to the application.properties configuration
  file to support rolling up log files.
  - The following miscellaneous installation enhancements have
  been added:
      - If a certificate or keyring for the Liberty server is not
  specified during installation, a default self-signed
  certificate is used.
      - If the path for the wlp_user_dir folder contains white
  space, the white space is removed.
  

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:

  UO03844

Modules/Macros

• DSN5DTMS DSN5INSH
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UO03844

     UP25/06/28 P F506  

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.