IBM Support

PH63509: SQL TUNING SERVICES INTERNAL ENHANCEMENT.

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PH63509

  • Reported component name

    SQL TUNING SERV

  • Reported component ID

    5655R1406

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2024-10-01

  • Closed date

    2024-11-18

  • Last modified date

    2024-12-03

  • 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.

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"210"}]

Document Information

Modified date:
03 December 2024