PH13106: IBM Db2 AI for z/OS New Function

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• IBM Db2 AI for z/OS New Function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Db2 AI for z/OS V1.2 users                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IBM Db2 AI for z/OS New Function                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  APARs PH11306 and PH13106 provide the following updates to
  IBM Db2 AI for z/OS (Db2ZAI):
  
  The Db2ZAI model training service has been enhanced with
  the addition of a model retraining API for model retraining
  purposes. 
  
  Db2ZAI now has enhanced security through support for 
  SSL/TLS for the model training service.
  
  Db2ZAI no longer requires ODBC. The Db2ZAI backend data
  service has converted from using IBM Db2 ODBC for the z/OS
  connection to using the JDBC connection when connecting to
  an IBM Db2 for z/OS database.  A set of new data service
  APIs has been deployed for this ODBC to JDBC conversion.
  
  The Db2ZAI system assessment feature has been enhanced to
  support a new graphical zooming capability to make it
  easier to perform deeper performance analyses.  Additional
  capabilities added include the ability to dynamically
  select subsets of Db2 subsystems and performance metrics
  as part of interactive analysis.
  
  The Db2ZAI catalog table objects, stored procedures, and
  user-defined functions have been updated to support new
  features such as SQL optimization package metrics and
  statement metrics tables.
  
  The Db2ZAI user interface has been enhanced as follows:
  - The SQL Optimization page now has three tabs
    -- SQL Metrics
    -- Model table
    -- Package Selection
  - The SQL Metrics tab includes tables for package-level,
    statement-level, and access path-level metrics. 
  - The Scheduler page has been moved to the Db2 System
    Assessment page as the Scheduler tab.
  - As mentioned above, the Db2 System Assessment graphs
    now have an enhanced data visualization capability which
    reveals detailed system performance data by time period.  
  - The Db2 Dashboard and Connections page have been merged
    into one overall dashboard, making navigation simpler. 
  - The System Configuration page is now only accessible to
    system administrators with Db2 AI for z/OS user privilege. 
  - A new color theme and updated widgets have been implemented.
  
  Additional keywords
  DB2AIV1R2/K
  

Problem conclusion

• Db2ZAI code has been updated as described above.
  

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:

  UI63835

Modules/Macros

• COYCATLG COYBACK  COYNOD01
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R120 PSY UI63835

     UP19/06/26 P F906

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.