PH62113: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 AI for z/OS (Db2ZAI)        *
  *                 version 1.6.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixed customers' reported     *
  *                      issues as well as the internal          *
  *                      finding issues.                         *
  ****************************************************************
  SQL optimization:
  - Updated internal stored procedures to improve performance
  - Extended the clean-up job for the Db2ZAI object
    SYSML.DSN_ML_SQL_PERF_HIST to cover the timeline based
    on PREV_EXEC_TIME_MAX
  - Enhanced the functionality that performs access path
    exploration and the deployment of recommended access paths
  - Minor fixes to the SQL optimization user interface
  - Corrected the encoding order for the access path plan
  Distributed Connection Control:
  - Corrected the label name on the Client Information page
  - Fixed the ability to apply recommended threshold values
    across a data sharing group without requiring a
    recommendation change on the source subsystem.
  - Fixed the inaccurate status display for profile attributes
    that do not exist in the DSN_PROFILE_ATTRIBUTES table.
  System Assessment (SA):
  - Updated to use PassTickets for Db2 connections
    established by Spark during SA and SA training executions
  - Enhanced the logic for continuous exception detection to
    minimize false positives
  - Updated the recommendation text for some exceptions
  Infrastructure:
  - Enhanced RACF access control for the user interface.
  - Enhanced SMTP configuration
  - Resolved issue with cleanup thread termination during
    Db2 shutdown
  - Reduced CPU usage by NodeJS. The number of NodeJS address
    spaces that is required by Db2ZAI is reduced
  Additional keywords:
  DB2AIV1R6/K
  

Problem conclusion

Temporary fix

Comments

• This APAR provides fixes to the issues listed above. In
  addition, this APAR fixed some internal finding issues.
  Additional keyword:
  DB2AIV1R6/K
  

APAR Information

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

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

  UI99482

Modules/Macros

• COYAKIRA COYF050B COYF050D COYF060B COYF060E COYGMADM COYGMURO
  COYGPAD2 COYGPADM COYGPDCC COYGPSA2 COYGPSID COYGPSQ2 COYIMC00
  COYIMC01 COYIPC00 COYIPC01 COYIPC02 COYIPC04 COYMAIN  COYNOD01
  COYNOD02 COYPTK1  COYPTK2  COYPTK3M COYPTK3P COYREADM COYU050A
  COYU051A COYU060A COYU060B COYU060C COYU060D COYU061A COYU061B
  COYU061C COYU061D COYU062A COYU062B COYV050D COYV050F COYV056A
  COYV057A COYV057B COYV058A COYV059A COYV060A COYV060B COYV060C
  COYV060D COYV060E COYV060F COYV064F COYV065A COYV065B
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R160 PSY UI99482

     UP24/12/24 P F412  

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.