PH60870: NEW FUNCTION FOR SQL DATA INSIGHTS (SQL DI)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function for SQL Data Insights (SQL DI)
  Additional keywords: SQLDI DB2SQLDI/K SQLCODE20577
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 13 for z/OS                 *
  *                 SQL Data Insights (SQL DI)                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: This is a new function APAR for the     *
  *                      SQL DI feature that provides the        *
  *                      model retraining capability.            *
  ****************************************************************
  This APAR introduces the model retraining capability of SQL DI.
  This new capability allows you to retrain an object model while
  the existing one is still in use for production. To use the new
  capability, you must apply the required APARS from the
  functional components of Db2, z/OS, and SQL DI UI.
  Refer to the ++HOLD text and the
  'Installing and Configuring SQL DI' section in the Db2
  SQL Data Insights documentation for detailed instructions.
  
  This APAR also introduces minor changes and enhancements to the
  existing object models that include the following items:
  
  - The AI_COMMONALITY function returns SQLCODE +20577 with
    reason code 1 when it is executed on a model that was trained
    prior to the application of the required APARs.
  
  - Db2 built-in functions (AI_SIMILARITY, AI_ANALOGY,
    AI_SEMANTIC_CLUSTER, and AI_COMMONALITY) for SQL DI no longer
    accept CHAR FOR BIT DATA or VARCHAR FOR BIT DATA in their
    arguments.  This restriction is also enforced when a new
    model is trained in the SQL DI UI. This restriction is
    introduced to prevent any invalid use of binary data in
    SQL DI.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  UI96864

Modules/Macros

• DSNGEPLC DSNTIA1  DSNTIAM  DSNTIJAI DSNXDMPS DSNXEAAL DSNXEALS
  DSNXEBIS DSNXECMP DSNXECT  DSNXEDP  DSNXEDS1 DSNXEDSC DSNXEET
  DSNXELS1 DSNXEMG1 DSNXERT  DSNXERT2 DSNXESDL DSNXESES DSNXESQL
  DSNXESX  DSNXESX4 DSNXGAIF DSNXLECE DSNXOAIF DSNXOBFA DSNXOBFF
  DSNXOBFP DSNXOCU  DSNXODTX DSNXOEA  DSNXOEXF DSNXOFN2 DSNXOFPD
  DSNXOLL  DSNXOOS2 DSNXOPCO DSNXOQAI DSNXSTSE DSNXZAIL DSNXZAIR
  DSNXZBAT DSNXZDST DSNXZPRO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI96864

     UP24/05/25 P F405  

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.