IBM Support

PH49809: 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:                                              *
    * All users of Db2 AI for z/OS version 1.5                     *
    * (Db2ZAI).                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This APAR adds toleration for the new                        *
    * Db2 EXPLAIN format introduced by Db2                         *
    * APAR PH44421.                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This Db2ZAI APAR adds toleration for the new Db2 EXPLAIN format
    introduced by Db2 APAR PH44421. This APAR is required for
    all Db2ZAI users that have Db2ZAI SQL optimization (SQLOPT)
    running. When Db2ZAI SQLOPT is running without this APAR and
    the target Db2 has PH44421 applied, the Db2ZAI SQL optimization
    statement page will not display the access path details.
    Additional keyword:
    DB2AIV1R5/K
    

Problem conclusion

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • This Db2ZAI APAR provides the fix as described above.
    

APAR Information

  • APAR number

    PH49809

  • Reported component name

    DB2 AI FOR Z/OS

  • Reported component ID

    5698CGN00

  • Reported release

    150

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-09-26

  • Closed date

    2022-12-02

  • Last modified date

    2023-01-03

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

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

    UI83569

Modules/Macros

  • COYAKIRA COYREADM
    

Fix information

  • Fixed component name

    DB2 AI FOR Z/OS

  • Fixed component ID

    5698CGN00

Applicable component levels

  • R150 PSY UI83569

       UP22/12/06 P F212 ¢

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 Systems"}],"Version":"150"}]

Document Information

Modified date:
05 January 2023