IBM Support

PH46488: ABEND MIGHT OCCUR WHEN CALLING DB2 SQL DATA INSIGHTS BUILT-IN FUNCTIONS (AI_SIMILARITY, AI_ANALOGY, AI_SEMANTIC_CLUSTER)

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Following abend might occur when calling Db2 SQL Data Insights
    built-in functions (AI_SIMILARITY, AI_ANALOGY,
    AI_SEMANTIC_CLUSTER).
    DUMP TITLE=COMPON=CEL,COMPID=568819801,ISSUER=CELAFRR ,
    MODULE=CELAEICT+????,ABEND=U4039,REASON=00000000
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 13 for z/OS users who use Db2 SQL                    *
    * Data Insights functions.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ABEND=U4039,REASON=00000000 in module                        *
    * CELAEICT might occur when calling the                        *
    * Db2 SQL Data Insights built-in                               *
    * functions which are AI_SIMILARITY,                           *
    * AI_ANALOGY and AI_SEMANTIC_CLUSTER.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Db2 SQL Data Insights functions call a C library to do semantic
    arithmetic. The C library does not expect the mask bits in the
    Floating-Point-Control register to be on. When the bits are on,
    the ABEND might occur in the C library.
    Also adding a serviceability improvement for acceleration mode.
    

Problem conclusion

  • Db2 is modified to ensure that the mask bits in the
    Floating-Point-Control register are off when calling the C
    library.
    The serviceability improvement for the acceleration mode has
    been implemented.
    Additional keywords: DB2SQLDI ABENDU4039 RC00000000
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH46488

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-05-16

  • Closed date

    2022-06-07

  • Last modified date

    2022-09-08

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

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

    UI80917

Modules/Macros

  • DSNDQWPZ DSNXZAIR DSNDSPRM DSN6SPRC DSNXLECE
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RD10 PSY UI80917

       UP22/06/15 P F206

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:
08 September 2022