PK31295: REFLECT DB2 CHANGES FOR QWACBSC IN PK12365/UK10142 AND OTHER CHANGES IN ACCOUNTING REPORTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Changes to QWACBSC by DB2 in PK12365/UK10142 require
  modifications to the ROLLUP ACCOUNTING RECORDS displayed by
  accounting reports.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. The changes by DB2 PK12365/UK10142   *
  *                      a in Batch Accounting Traces.           *
  *                      Field QWACBSC (BEGIN TIME               *
  *                      of the IDENTIFICATION block) shows N/P  *
  *                      in case of rollup data.                 *
  *                                                              *
  *                      2. In case of rollup data field ADTCBT  *
  *                      (#TCB TIME, shown in Accounting Reports *
  *                      if selected by UTR) does not include    *
  *                      QWACEJST.                               *
  *                                                              *
  *                      3. The Accounting process needed to be  *
  *                      reworked.                               *
  *                                                              *
  *                      4. In case of DDF/RRSAF rollup data     *
  *                      (ACCUMAC) field QWACESC (END TIME) of   *
  *                      the IDENTIFICATION block in Accounting  *
  *                      Trace  shows an elapsed time.           *
  *                                                              *
  *                      5. In case of DDF/RRSAF rollup data     *
  *                      (ACCUMAC) field ASOCCURS (#OCCURRENCES) *
  *                      of the HIGHLIGHTS block in Accounting   *
  *                      Reports might be incorrect.             *
  *                                                              *
  *                      6. In case of DDF/RRSAF rollup data     *
  *                      field ADTOTPOC (OCCURRENCES) of the     *
  *                      PACKAGE ACTIVITY IDENTIFICATION         *
  *                      block in Accounting Reports might be    *
  *                      incorrect.                              *
  *                                                              *
  *                      7. Field QBGAGG, the GETPAGES of the    *
  *                      total GROUP BUFFER POOL block is        *
  *                      always 0.                               *
  *                                                              *
  *                      8. In case of DDF/RRSAF rollup data the *
  *                      rolled up package is named 'BLANK'.     *
  *                      9. Message FPEA4536I or                 *
  *                      FPEA4537I might be thrown for           *
  *                      data created on a DB2 subsystem         *
  *                      which has installed the PTF for         *
  *                      Apar PK28561.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• 1. By this PTF DB2 Performance Expert
  reflects the changes for field QWACBSC.
  Code has been changed to show a
  timestamp again. It is the earliest begin
  store clock value for a thread that
  has rolled data into the record.
  
  2. In case of rollup data field #TCB TIME contains the elapsed
  time QWACEJST now.
  
  3. Rework has been done. The different types of records can be
  identified correctly and processed accordingly.
  
  4. Although this is correct based on DB2's field definition,
  END TIME shows N/P now. The rollup elapsed time of
  QWACESC is reported under Class 1 Elapsed Time.
  
  5. In case of DDF/RRSAF rollup data field ASOCCURS shows
  the  number accounting intervals rolled up in a record.
  
  6. In case of DDF/RRSAF rollup data field ADTOTPOC shows the
  number of accounting intervals rolled up in a record.
  7. GETPAGES of the total GROUP BUFFER POOL shows now the
  accumulated value.
  8. In case of DDF/RRSAF rollup data the rolled up package is
  named *ROLLUP*.
  9. The messages will not be thrown under such conditions.
  

Temporary fix

Comments

• ***************
  

APAR Information

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

  PK24958

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

  UK18926 PK33459

Modules/Macros

•    DGOAACUM DGOABLOG DGOABORD DGOABORE DGOABSGE
  DGOABSPK DGOACALC DGOACALX DGOACMER DGOACOMP DGOACREC DGOADIST
  DGOADNOR DGOADSGE DGOADSPK DGOAEXIT DGOAEX20 DGOAFGEN DGOAFLAT
  DGOAFPCK DGOAIREC DGOALUMP DGOAMTRC DGOAPARC DGOAQKEY DGOARCAL
  DGOAREDB DGOAREDC DGOAREDD DGOAREDG DGOAREDM DGOAREDP DGOAREDR
  DGOAREDX DGOARXIT DGOASAVE DGOATOPR DGOATPRC DGOATRAC DGOATREC
  DGOAZMER DGOAZREC DGOBARDD DGOBARLK DGOBARLO DGOBARPK DGOBARPO
  DGOBARPT DGOBARRI DGOBARRL DGOBARSH DGOBARSP DGOBARSQ DGOBARTE
  DGOBARTM DGOBATDD DGOBATLK DGOBATLO DGOBATPK DGOBATPO DGOBATPT
  DGOBATRI DGOBATRL DGOBATSH DGOBATSP DGOBATSQ DGOBATTM DGOBGENL
  DGOER000 DGOFECAL DGOFECA2 DGOFEDAT DGOFEPKG DGOFPDAT DGOFPRIC
  DGOMTADJ DGOMTLST DGOMTPKG DGOMTPOP DGOPACNV DGOPA510 DGOPA610
  DGOPA710 DGOPA830 DGORAEXT DGORIREP DGORPACC DGORUACC DGORZREP
  DGOVSADJ DGOVSCNT DGOVSCS2 DGOVSCT1 DGOVSCT2 FPECMDAT FPEUCBPR
  FPEUIFCI FPEUIFC2 FPEUNIDT
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK18926

     UP06/10/31 P F610

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.