PH48788: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides new functionalities
  for Db2ZAI 1.5.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 AI for z/OS 1.5 users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Reported Db2ZAI issues:                                      *
  * - The Db2ZAI configuration update                            *
  * script inserted the incorrect host or                        *
  * IP address value for the Db2ZAI                              *
  * instance in the                                              *
  * <schema>.DSN_ML_MEMBERS table.                               *
  * - The Db2ZAI edit target connection                          *
  * page failed to save the Db2                                  *
  * information due an extra keyword being                       *
  * passed to the updateDatasource API                           *
  * service.                                                     *
  * - The Distributed connection control                         *
  * (DCC) priority page cannot load the IP                       *
  * address list because of an                                   *
  * authorization error for the read only                        *
  * user.                                                        *
  * - The SQL optimization dashboard                             *
  * showed resolved regression                                   *
  * recommendations for statements that                          *
  * were auto-resolved by Db2ZAI.                                *
  * - The SQL optimization dashboard                             *
  * showed an incorrect resolved                                 *
  * regression count by excluding the                            *
  * statements where the access path                             *
  * regression was manually resolved.                            *
  * - The scheduleUpdateSystemStatusTask                         *
  * task did not have the persistent timer                       *
  * enabled.                                                     *
  * - In a high availability                                     *
  * configuration, the Db2ZAI system                             *
  * configuration page did not propagate                         *
  * the new Db2 information for the Db2ZAI                       *
  * metadata across all its Db2ZAI                               *
  * instance members.                                            *
  * Db2ZAI enhancement:                                          *
  * - Query performance has been enhanced                        *
  * for the getPivotReportData API                               *
  * service.                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This Db2ZAI APAR provides fixes and enhancement for items
  listed above.
  

Problem conclusion

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• Additional keyword
  DB2ZAIV1R5/K
  

APAR Information

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

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

  UI82676

Modules/Macros

• COYAKIRA COYGPSID COYGPSQL COYNOD02 COYREADM COYIPC02 COYV050F
  COYV050G COYMAIN  COYNOD01
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R150 PSY UI82676

     UP22/10/05 P F210 ¢

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.