PH19816: 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 IBM Db2 AI for z/OS users may be                         *
  * affected                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * APAR PH19816 provides the following                          *
  * enhancements to IBM Db2 AI for z/OS                          *
  * (Db2ZAI) version 1.2.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  APAR PH19816 provides the following enhancements to
  IBM Db2 AI for z/OS (Db2ZAI) version 1.2.
   
  List of Db2ZAI enhancements:
   
  *Db2ZAI user management
  Db2ZAI user management is a new feature that allows Db2ZAI
  installation administrators and Db2ZAI system administrators
  to authenticate existing z/OS RACF users to Db2ZAI with one
  of the following roles:
  1. Db2ZAI Installation Administrators can administer the
  Db2ZAI web portal configuration.
  2. Db2ZAI System Administrator is a super administrator role
  that has all the authorities of the Db2ZAI Installation
  Administrator, plus the ability to administer all Db2ZAI
  connections to Db2.
  3. Db2ZAI User is the normal Db2ZAI user role that has the
  ability to add a new Db2 connections and to administer the
  Db2 connections the user has created.
  
   
  *Dynamic Tabbing
  Clicking a package name on the SQL Metrics tab of the
  SQL Optimization page opens the statement metrics for the
  package in a new tab. On the Statement Metrics tab, clicking
  a statement hash ID opens the access path metrics for that
  statement.
   
  *Statement Metrics Layout
  Removed unnecessary columns in order to improve readability.
  Added a statement text preview to each row, and full statement
  text is viewable by clicking on the preview.
   
  *Package Metrics Layout
  Removed unnecessary columns in order to improve readability.
  Changed always-available action options into icons to flatten
  the row and make more packages visible at once.
   
  *Package Metrics Search
  Added search capability to package metrics. Users are able to
  search by collection ID, package name, or a combination
  formatted as <collid>.<name>.
   
  *Improved Loading
  Added loading animation to Package Metrics and SQL Metrics
  to give users an indication that data is still being retrieved.
   
  *Db2ZAI Assessment On-Demand
  Db2ZAI Assessment On-Demand is a new feature that enables
  users to run ad hoc system assessments based on a custom
  timeframe for Db2 statistics data.
   
  *Db2ZAI Enhanced Assessment Rules
  Db2ZAI has enhanced system assessment rules and
  recommendations in the area of buffer pool performance.
   
  *Db2ZAI Catalog
  Db2ZAI catalog table objects, stored procedures, and
  user-defined functions have been updated to support all
  of the new features listed above.
   
  *Db2ZAI User Interface SQL statements optimization
  SQL statements in Db2ZAI have been optimized to perform faster
  with larger tables.
   
  Additional keywords
  DB2AIV1R2/K
  

Problem conclusion

• The Db2ZAI code has been updated as described above.
  

Temporary fix

Comments

• ×**** PE19/12/02 FIX IN ERROR. SEE APAR PH19817  FOR DESCRIPTION
  

APAR Information

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

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

  UI67038

Modules/Macros

• COYREADM COYNOD02 COYCATLG COYAKIRA COYZAISP COYBACK  COYDAEMN
  COYZAIST COYMAIN  COYNOD01
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R120 PSY UI67038

     UP19/12/18 P F912

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.