IBM Support

PH39038: SQL TUNING SERVICE ENHANCEMENTS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR includes the following improvements:
    Expanded SQL Capture filter options
    Enhanced Connection Profile Management API
    Enhanced API serviceability
    Updated Swagger doc
    Fixed minor defects in the Visual Explainer, SQL Formatter, SQL
    Capture, and Connection Profile Management APIs and in the
    installation process
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All the SQL tuninng service users.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This PTF includes the following                              *
    * improvements:                                                *
    * Expanded SQL Capture filter options                          *
    * Enhanced Connection Profile                                  *
    * Management API                                               *
    * Enhanced API serviceability                                  *
    * Updated Swagger doc                                          *
    * Fixed minor defects in the Visual                            *
    * Explainer, SQL Formatter, SQL Capture                        *
    * ,and Connection Profile Management                           *
    * APIs and in the installation process                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    This PTF includes the following
    improvements:
    Expanded SQL Capture filter options
    Enhanced Connection Profile Management
    API
    Enhanced API serviceability
    Updated Swagger doc
    Fixed minor defects in the Visual
    Explainer, SQL Formatter, SQL Capture,
    and Connection Profile Management APIs
    and in the installation process
    

Problem conclusion

  • This PTF includes the following
    improvements:
    Expanded SQL Capture filter options
    Enhanced Connection Profile Management
    API
    Enhanced API serviceability
    Updated Swagger doc
    Fixed minor defects in the Visual
    Explainer, SQL Formatter, SQL Capture,
    and Connection Profile Management APIs
    and in the installation process
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH39038

  • Reported component name

    SQL TUNING SERV

  • Reported component ID

    5655R1406

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-07-16

  • Closed date

    2021-09-03

  • Last modified date

    2021-10-01

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

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

    UI76396

Modules/Macros

  • DSN5DTMS DSN5INSH
    

Fix information

  • Fixed component name

    SQL TUNING SERV

  • Fixed component ID

    5655R1406

Applicable component levels

  • R110 PSY UI76396

       UP21/09/20 P F109

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"110"}]

Document Information

Modified date:
02 October 2021