PH56435: 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.5.                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR fixes reported issues and                          *
  * makes small enhancements.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Here is the list of fixed issues in this APAR:
  - Non-printable X'05' characters found in several members of
  the hlq.SCOYSAMP dataset. This APAR removes all non-printable
  X'05' characters.
  - The Db2ZAI monitor task that checks for server heartbeats
  during startup or stopping of the Db2ZAI started task times
  out at 60 minutes, which is too long. This APAR changes the
  60-minute timeout to a 5-minute timeout.
  - The backup pseudo-catalog COYF050B job did not complete
  successfully, and the COYBKC15 job abended with S322. This
  APAR fixes these two issues.
  - The config.sh script did not allow some valid time zones.
  The script now allows all valid time zones.
  -Db2 shutdown would hang due to a long-running Db2ZAI
  clean-up task. Also, this clean-up task can cause high CPU
  utilization in the DBM1 address space. This clean-up task has
  been optimized to run faster and to use less CPU.
  - The Db2ZAI SQL statement detail showed incorrect metric
  values for baseline and current access paths after clean-up.
  This APAR fixes the incorrect metric values.
  - The Db2ZAI SQL dashboard showed incorrect metric values for
  "Actions to take now." This APAR fixes these incorrect metric
  values.
  - When the LOB space is over 32K, the unload job would fail.
  This APAR moves the LOB columns to the end of the unload
  statements for the SYSMLQAH and SYSMLQSH tablespaces in the
  spanned record format.
  - This APAR also fixes other miscellaneous issues.
  Here is the list of enhancements in this APAR:
  - Improves the performance of the following stored procedures:
  INSERT_UI_METRICS_15, CREATE_OFNR_SIMPLE_MODELS_15,
  CREATE_HVAR_SIMPLE_MODELS_15.
  - Adds revoke statements to all of the grant jobs.
  - Adds the COYIMC00 job to drop the Db2ZAI metadata database.
  - Adds the COYIPC00 job to drop the Db2ZAI target connection
  catalog.
  - Updates the unload job to exclude system assessment raw
  tables.
  Additional keyword:
  DB2AIV1R5/K
  

Problem conclusion

Temporary fix

Comments

• This APAR provides fixes to the issues and makes the
  enhancements described above.
  

APAR Information

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

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

  UI94880

Modules/Macros

• COYV050K COYGPSAR COYV050F COYV050H COYV050B COYCATLG COYV050D
  COYAKIRA COYIMC01 COYV043B COYIMC00 COYV041A COYNOD02 COYV041C
  COYREADM COYV057A COYGPDC2 COYV057B COYGPSQ2 COYV043A COYF050D
  COYF050B COYGMSID COYGPADM COYNOD01 COYGMUSR COYGPDCC COYGPSA2
  COYIPC00 COYGPSID COYGPSQL COYGMADM COYGPAD2 COYV042B COYV054C
  COYV050A COYIPC01 COYGPDCR COYIPC02 COYGPSQR COYV044A COYV054A
  COYGMURO COYMAIN  COYGPSA
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R150 PSY UI94880

     UP23/12/16 P F312

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.