PH64801: 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 Db2 AI for z/OS (Db2ZAI) users with      *
  *                 Db2 13 for z/OS as the target connection.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces new features and   *
  *                      enhancements (V1.6.2) to Db2ZAI with    *
  *                      Db2 13 for z/OS as the target           *
  *                      connection.                             *
  ****************************************************************
  Db2ZAI System assessment (SA) new features and enhancements:
  
  -The ability to run assessments against the data from Db2
  subsystems that are not connected to Db2ZAI.
  
  -The ability to select the exception types and categories when
  performing system assessments.
  
  -The flexibility to schedule multiple recurring assessments
  with shorter time frames than 24 hours.
  
  -New APIs have been provided to run an assessment on demand, as
  well as system assessment training.
  
  
  
  Db2ZAI SQL optimization key enhancements:
  
  -Access path performance analysis is improved by using
  confidence level to avoid premature actions being taken before
  enough data is analyzed.
  
  -A new option to select dynamic SQL statements with filtering,
  using the client user ID and the client application name or
  both.  Automatic dynamic SQL statement selection is updated
  to select statements based on CPU consumption.
  
  -The selection of static packages is enhanced to allow the
  specification of the collection ID without package names.
  
  -QUERYNO information for dynamic SQL is added in the statement
  details.
  
  Db2ZAI Distributed connection control (DCC) key enhancements:
  
  -Connection information has been added to the DCC dashboard as
  well as the ability to drill-down on client inventory
  information for better analysis and troubleshooting.
  
  -The DCC feature now allows users to suppress Db2 console
  messages, reducing messages on the z/OS console as DCC learns
  about the user's workload when Db2 13 APAR PH65972 is applied.
  
  -Db2ZAI infrastructure new features and enhancements:
  
  -To simplify maintenance updates,  Db2ZAI generates
  migration steps dynamically based on the maintenance level.
  This will create all necessary steps in a single JCL job for a
  metadata connection and the target connections.
  
  -The cleanup process has been modified to limit data deletion
  to a maximum of 24 hour's worth of data per day to minimize
  the possible overhead.
  
  -Users have the option to configure and update Db2ZAI using a
  configuration file in addition to the current command prompt
  interface.  This enables users to automate Db2ZAI
  configuration.
  
  -Db2ZAI no longer stores passwords for the scheduler IDs for
  both target and metadata connections.
  
  With Db2 APAR PH66471,  the Db2 - START,  STOP and
  DISPLAY ML commands are enhanced to support the set of Db2ZAI
  enhancements described above.
  

Problem conclusion

Temporary fix

Comments

• This APAR introduces the new features and enhancements
  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:

  UO04012

Modules/Macros

• COYAKIRA COYALLOC COYCATLG COYCMC01 COYCONFG COYCPC01 COYCZZ00
  COYF060A COYF060B COYF060E COYGIAD2 COYGIADM COYGISA  COYGMSID
  COYGMURO COYGMUSR COYGPSID COYGPSQ2 COYGPSQL COYGPSQR COYGRAD2
  COYGRADM COYIIC01 COYIMC01 COYIPC00 COYIPC01 COYIPC02 COYIRC01
  COYIRC02 COYIVCFG COYIVIC  COYIVRC  COYMAIN  COYMIGRM COYMIGRT
  COYMMCM1 COYMPCD1 COYMPCM1 COYMPCM2 COYMPCR0 COYMPCR1 COYMTEXT
  COYMZZ00 COYMZZ01 COYMZZ02 COYMZZ03 COYNOTC2 COYNOTIC COYREADM
  COYU060C COYU063A COYUILOD COYURULD COYV062A
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R160 PSY UO04012

     UP25/07/12 P F507  

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.