IBM Support

PH41758: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New Function
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
    *                 users of components                          *
    *                 IBM Db2 SQL Performance Analyzer             *
    *                 users of components                          *
    *                 - ISPF and Batch Process packages from the   *
    *                 DB2 system catalog                           *
    *                 - ISPF and Batch Process application DBRM    *
    *                 - ISPF and Batch Process SQL from a          *
    *                 sequential data set or PDS member            *
    *                 - ISPF and Batch Process SQL from program    *
    *                 source                                       *
    *                 - ISPF and Batch Process a query number from *
    *                 the plan table                               *
    *                 - ISPF and Batch Process a QMF statement     *
    *                 - Create Index                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: New Functions                           *
    *                      1. Support of temporal tables for       *
    *                      basic functions of SQL PA               *
    *                      2. Set parameters for creation new      *
    *                      index prqty/seqty/stogroup/bufferpool   *
    *                      as optional                             *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    New Function. See Description.
    

Problem conclusion

  • Code was added to implement the enhancements.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41758

  • Reported component name

    DB2 SQL PERF AN

  • Reported component ID

    5697F5701

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2021-11-01

  • Closed date

    2022-01-05

  • Last modified date

    2022-02-01

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

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

    UI78809

Modules/Macros

  • ANLBATCH ANLCAT   ANLCBTCH ANLCHECK ANLCLOB  ANLCMIGR ANLCRNE1
    ANLCRNS1 ANLCRNT1 ANLCSV   ANLDB2X  ANLDPRM  ANLEEE   ANLGPRM
    ANLGPST  ANLH11   ANLJB001 ANLJB002 ANLMAIN  ANLNUXD  ANLPDBRM
    ANLPFILE ANLPH117 ANLPH118 ANLPH200 ANLPH210 ANLPH211 ANLPH212
    ANLPH300 ANLPH302 ANLPH400 ANLPH401 ANLPICP  ANLPIDD  ANLPIQLR
    ANLPITP  ANLPLAN  ANLPLIM1 ANLPLIM2 ANLPLIN  ANLPNUXR ANLPOPTS
    ANLPPKGE ANLPRCR  ANLPRER  ANLPTBLF ANLPTCM  ANLPTEX  ANLPTLD
    ANLPTRP  ANLPTSM  ANLQMF   ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS
    ANLTSO   ANLVER8  ANLWIF
    

Fix information

  • Fixed component name

    DB2 SQL PERF AN

  • Fixed component ID

    5697F5701

Applicable component levels

  • R510 PSY UI78809

       UP22/01/06 P F201  

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0"}]

Document Information

Modified date:
02 February 2022