PH18334: DB2 12 FOR Z/OS NEW FUNCTION FOR USERS OF IBM DB2 ANALYTICS ACCELERATOR W/INTEGRATED SYNC AS THE INCREMENTAL UPDATE METHOD

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New function is added to DB2 for z/OS to capture CPU consumption
  involved with Integrated Synchronization method for incremental
   updates.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who use IBM Db2                    *
  * Analytics Accelerator with Integrated                        *
  * Synchronization as the incremental update                    *
  * method.                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides:                                          *
  * * Updates to Db2 statistics traces to                        *
  *   record CP and zIIP consumption by                          *
  *   asynchronous log reader tasks that                         *
  *   are started on behalf of Integrated                        *
  *   Synchonization to IBM Db2 Analytics                        *
  *   Accelerator                                                *
  * * Updates to the product ID in Db2                           *
  *   accounting traces to identify                              *
  *   threads that are used to retrieve                          *
  *   data from these asynchronous log                           *
  *   reader tasks                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Details of the updates provided by this APAR:
  When Db2 tables are enabled for incremental updates using
  Integrated Synchronization to IBM Db2 Analytics Accelerator,
  Db2 uses a statistics trace for IFCID 2 to collect data on CP
  and zIIP consumption during log record capture. Global values
  for all asynchronous log reader tasks are accumulated in data
  section QIST (fields QISTLRCP, QISTLRZI, and QISTLRZE).
  CPU, zIIP, and zIIP on CP times are captured and represent the
  total time accumulated since Db2 has been started.
  Distributed threads from accelerators retrieving log records
  will be classified using correlation name "IN_SYNCH" and
  product ID "LRT010101" for unique identification in
  accounting IFCID 3 records.
  Additional keywords:
  IDAAV7R5/K
  

Problem conclusion

Temporary fix

Comments

• Db2 has been modified to collect and report CP and zIIP
  consumption that is associated with incremental updates to
  an accelerator when Integrated Synchronization is used. See
  the version of DSNWMSGS that is shipped with this APAR for
  the new and updated field descriptions.
  

APAR Information

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

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

  UI70139

Modules/Macros

• DSNX8STA DSNX8EKG DSNILGWD DSNLJHPP DSNIERST DSNX8SMF DSNDQIST
  DSNDQMDA DSNITSTA DSNTSTRT DSNILGRT DSNLJMCF DSNLIRTR DSNLJMLR
  DSNWMSGS DSNTDSTE DSNIOBDJ DSNLJTIN DSNDQ8ST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI70139

     UP20/06/27 P F006

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.