IBM Support

PH51892: 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 Db2 for z/OS V13 SQL Data Insights                       *
    * (SQL DI) users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This is a new function APAR to provide                       *
    * performance and functional                                   *
    * improvements for SQL DI.                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR introduces the implementation of prefetching and
    processing multiple vectors at time which speeds up SQL DI
    query processing.  It also improves the SQL DI scoring
    performance for AI_SEMANTIC_CLUSTER function and
    generates more accurate scoring results.
    

Problem conclusion

Temporary fix

Comments

  • Db2 is modified to provide performance and functional
    improvements for SQL DI.
    

APAR Information

  • APAR number

    PH51892

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-01-12

  • Closed date

    2023-02-15

  • Last modified date

    2023-04-03

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

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

Modules/Macros

  • DSNXSTSG DSNXSTSE DSNXECT  DSNXOAIF DSNTIDXA DSNTINST DSNTIDXC
    DSNTIWIA DSNTIDXB DSNTIWMD DSNXOSR  DSNXEMG1 DSNTIWIE DSNXOGA
    DSNXESX  DSNXZEU2 DSNXZEU1 DSNTTEPL DSNXGAIF DSNXRT1J DSNXRSPG
    DSNXZPRO DSNXSORI DSNXOPTI DSNTXAZP DSNTIP81 DSNXESX4 DSNXSMRG
    DSNXEBIS DSNXOFPD DSNXSMRE DSNDSPRM DSNXOPCO DSNXOQAI DSNXERT
    DSNXEDS1 DSNXZAIL DSNXOOS2 DSNTIWMN DSNXZDST DSNTIWMS DSNXIEPL
    DSNXZAIR DSNTIWAF DSNTIWIN DSNXELS1 DSNXEALS DSNDQWAC DSNXLECE
    DSNTINMF DSNXEET  DSNDQWPZ DSNWZIFD DSNTIVMD DSNXESDL DSNTIJUZ
    DSNTIVIA DSNXGRTS DSNXOML  DSNXOEA  DSNXLETI DSNTIJAI DSNTIVIE
    DSNXEDSC DSNXOEXF DSNWMSGS DSNXOFN2 DSNXECMP DSN@XAZP DSNWVZPS
    DSNXRFN  DSN6SPRM DSNXOBFF DSNXDMPS DSNXERT2 DSNXZBAT DSNTXSTB
    DSNXEDP  DSNXELX  DSNTIWPC DSNXEAAL DSNXRFF  DSNXRRP  DSNXOBFA
    DSNTIVMN DSNGEPLC DSNXESES DSNXRBND DSNXOPRW DSNTIVAF DSNTIVIN
    DSNXOCU  DSNXOMPS DSNTIVMS DSNTTRUN DSNXOBFP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RD10 PSY UI90547

       UP23/03/02 P F303

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 April 2023