PH51796: DB2ZAI 1.5 NEW FUNCTION 23/07/17 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2ZAI 1.5 New Function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 AI for z/OS version 1.5                     *
  * (Db2ZAI).                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2ZAI users reported the following                          *
  * issues:                                                      *
  * - The Db2ZAI Liberty address space                           *
  * shows high EXCP counts at every 1                            *
  * minute interval                                              *
  * - The metadata scheduler ID and target                       *
  * scheduler ID can be revoked when the                         *
  * enableSysplexWLB parameter is enabled.                       *
  * - DEADLOCK CORRELATION-ID=022.MLSIM                          *
  * RESOURCE NAME DSNMLDB1.SYSMLUSC                              *
  * - High CPU consumption for navigating                        *
  * the SQL optimization dashboard                               *
  * - INSERT_UI_METRICS_15 SQLCODE=-413                          *
  * SQLSTATE=22003                                               *
  * - The Db2ZAI sample JCL jobs in                              *
  * SCOYSAMP dataset have an incorrect                           *
  * dataset name that references the JCL                         *
  * members in SCOYSAMP                                          *
  * - The Db2ZAI Liberty started task                            *
  * writes its temp files into the system                        *
  * temp directory                                               *
  * - The Db2ZAI system assessment                               *
  * function cannot create the                                   *
  * SparkSession when running system                             *
  * assessments in local mode, because the                       *
  * Spark service cannot bind to a random                        *
  * port due to a missing authorization                          *
  * for the port                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  This APAR provides fixes to the issues listed above.
  In addition, this APAR resolves issues that were discovered
  internally and, in addition, provides usability enhancements
  based on user feedback.
  Additional keyword
  DB2AIV1R5/K
  

Problem conclusion

• This APAR provides fixes to the issues listed above.
  In addition, this APAR resolves issues that were discovered
  internally and, in addition, provides usability enhancements
  based on user feedback.
  The resolved internal issues and enhancements made in this APAR
  include:
  - New tooltips were added and some existing tooltips were
  improved, across all Db2ZAI features
  - A new button was added to the Performance insights dashboard
  to reset the analysis time frame to the last 24 hours
  - Corrected the issue where stacked plots may not
  fill with the correct colors
  - Added tooltips on stacked plots to show the data values from
  each category at the same time
  - Updated the tooltips and descriptions associated with various
  reports and plots
  - Enhanced the SQL optimization stored procedures to run more
  optimally
  - Resolved internal issues with the Distributed connections
  (DCC) feature related to searching, sorting, checkboxes,
  dropdowns, error handling messages, etc.
  - Added new sort capability to some columns for the DCC pages
  - Added a new topic to the documentation for system assessments
  to help with resource configuration in support of training and
  assessments
  - Updated the install.sh & update.sh scripts to support a
  user-specified Db2ZAI local Spark driver starting port and
  local Spark driver maxRetries attempts
  

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:

  UI90842 PH53095

Modules/Macros

• COYGPSAR COYAKIRA COYIMC01 COYV053A COYV041A COYV053B COYV041B
  COYV053C COYV041C COYV053D COYPTK2  COYGPDCC COYGPSA2 COYPTK1
  COYGPSID COYGPSQL COYV052A COYIPC01 COYGPDCR COYIPC02 COYGPSQR
  COYIPC03 COYV044A COYGMURO COYMAIN  COYU050A COYU050B COYV050J
  COYV050F COYV050G COYV050H COYV050I COYV050B COYCATLG COYV050C
  COYV050D COYV050E COYV043B COYNOD02 COYV051A COYV051B COYREADM
  COYIVPC  COYGPDC2 COYGPSQ2 COYV043A COYV050V COYGMSID COYGPADM
  COYPTK3M COYNOD01 COYV050S COYV050T COYPTK3P COYV050U COYU051A
  COYGMUSR COYIVMC  COYV041D COYV042A COYGMADM COYGPAD2 COYV042B
  COYV050A COYZAIST COYGPSA  COYU050C COYU050D COYZAISP
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R150 PSY UI90842

     UP23/03/10 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.