PH68316: DB2ZAI 1.6.3 ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2ZAI 1.6.3 enhancements:
  -Scheduled automation of SQLOPT exploration and
  deployment
  -SQLOPT includes 'client userid' and 'client applname'
  search to list dynamic SQL on SQLOPT dashboard
  -Change the metrics used for DCC Dashboard
  -Change metric used to trigger DCC training warning
  -Update system assessment exception detection
  rules and recommendations
  -Migration REXX script enhancement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 AI for z/OS (Db2ZAI) users.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces new enhancements   *
  *                      and addresses the problems described    *
  *                      in the Problem summary.                 *
  ****************************************************************
  Db2ZAI 1.6.3 introduces several key enhancements aimed at
  improving automation, usability, and the graphical display of
  data. To reduce manual intervention, Db2ZAI adds support for
  the automatic scheduling of SQL optimization processes.
  Schedules can be configured to run daily, weekly, or at a
  specified future time.
  
  Additionally, the SQL optimization feature now supports
  searching by client user ID and client APPLNAME, making it
  easier to identify and list dynamic SQL statements directly on
  the dashboard.
  
  A new scalar user-defined function
  'DSNML.DSN_ML_SQLOPT_SUMMARY_REPORT' is introduced to generate
  a summary of SQL optimization activities.
  
  Db2ZAI 1.6.3 also updates metrics displayed in the DCC
  dashboard to provide more accurate and useful information
  for analyzing DCC issues.
  
  This APAR also addresses the following reported issues for
  Db2ZAI:
  
  -The Spark block manager uses the default random option,
  causing potential bind failures when the port falls outside of
  the assigned range for Db2ZAI Spark.
  
  -One migration SQL statement references columns inside a table
  expression without assigning the required alias name, which
  results in SQLCODE +203 due to ambiguous or unresolved column
  references.
  
  -When SQL OPT recommendations are deployed with an empty list
  (for example, when no validated recommendations are available),
  the deployment process may incorrectly attempt to record an
  empty result which can cause a duplicate-record insert failure
  (SQLCODE -803) during subsequent deployments.
  
  -A timing issue with cached schema information could cause the
  creation of a new connection to fail.
  
  -The started task ID encountered file permission issues within
  the Db2ZAI home directory due to insufficient group privileges.
  
  -The DCC training algorithm fails to generate Db2 profile
  recommendations when Db2ZAI was configured using a hostname for
  the application server(s).
  
  -The Db2ZAI Liberty JVM doesn't automatically release memory
  back to the operating system after a system assessment has
  completed.
  

Problem conclusion

Temporary fix

Comments

• This APAR provides the enhancements and resolves the problems
  described above.
  
  Additional keyword:
  DB2ZAIV1R6/K
  

APAR Information

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

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

  UO06321

Modules/Macros

• COYAKIRA COYCATLG COYCMC01 COYCPC01 COYF060B COYF060G COYF060H
  COYF060I COYF060J COYGPSID COYGPSQL COYIIC00 COYIIC01 COYIMC01
  COYIPC00 COYIPC01 COYIPC02 COYIRC00 COYIRC01 COYIRC02 COYMAIN
  COYMIGRI COYMIGRM COYMIGRR COYMIGRT COYMMCM1 COYMPCM1 COYMPCR1
  COYMTEXT COYMZZ01 COYMZZ02 COYMZZ03 COYMZZ04 COYMZZ05 COYNOD01
  COYNOD02 COYREADM
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R160 PSY UO06321

     UP25/12/23 P F512  

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.