PH43949: DB2Z AI SQL OPTIMIZATION DASHBOARD DISPLAYS THE PACKAGE ERROR MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2z AI SQL optimization dashboard displays the package error
  message as the result of the backend API service that ran into
  java.lang.NullPointerException error.
  Additional keywords: DB2AIV1R4/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 AI for z/OS version 1.4                     *
  * (Db2ZAI)                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This Db2ZAI apar delivers the                                *
  * following fixes and enhancements:                            *
  * - Resolved the package error in the                          *
  * SQL optimization page                                        *
  * - Added the missing grant statement on                       *
  * the SYSML.DSN_ML_PERF_TRENDING_HISTORY                       *
  * table                                                        *
  * - Enhanced the logging functionality                         *
  * in the SQL optimization services                             *
  * - Updated message text for the DCC                           *
  * training data requirement                                    *
  * - Resolved the issue in which a simple                       *
  * model was generated before the data                          *
  * reached the threshold value                                  *
  * - Resolved the rebind recommendation                         *
  * issue                                                        *
  * - Resolved the issue of missing data                         *
  * in the DCC plots                                             *
  * - Resolved the zero values when there                        *
  * is no baseline value in the DCC                              *
  * scorecard                                                    *
  * - Enhanced data cleanup for the SQL                          *
  * optimization tables                                          *
  * - Enhanced the DCC training algorithm                        *
  * - Added the migration procedure for                          *
  * this APAR to the Db2ZAI documentation                        *
  * - Resolved the system assessment                             *
  * training failure that was caused by                          *
  * NULL values in the data                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  This Db2ZAI APAR provides fixes described as
  above.
  Additional keyword
  DB2AIV1R4/K
  

Problem conclusion

• This Db2ZAI APAR provides fixes described as
  above.
  

Temporary fix

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

Comments

APAR Information

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

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

  UI79862

Modules/Macros

• COYBACK  COYDAEMN COYCATLG COYV040D COYAKIRA COYV043B COYV042B
  COYNOD02 COYV040A COYREADM COYIPC01 COYIPC02 COYV043A COYMAIN
  COYGPSA  COYNOD01
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R140 PSY UI79862

     UP22/03/25 P F203 ¢

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.