PK33459: 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                 *
  *                 users of component:                          *
  *                 -   OMEGAMON Server                          *
  *                 -   Performance Expert Client                *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. The changes by DB2 PK12365/UK10142   *
  *                      are not reflected 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. In case of DDF/RRSAF rollup data     *
  *                      (ACCUMAC>1)                             *
  *                      field QWACESC (END TIME) of the         *
  *                      IDENTIFICATION block in Accounting      *
  *                      Trace shows an elapsed time.            *
  *                                                              *
  *                      4. In case of DDF/RRSAF rollup          *
  *                      data (ACCUMAC>1) field                  *
  *                      ASOCCURS (#OCCURRENCES) of the          *
  *                      HIGHLIGHTS block in Accounting          *
  *                      Reports might be incorrect.             *
  *                                                              *
  *                      5. In case of DDF/RRSAF rollup          *
  *                      data field ADTOTPOC (OCCURRENCES)       *
  *                      of the PACKAGE ACTIVITY                 *
  *                      IDENTIFICATION block in Accounting      *
  *                      Reports might be incorrect.             *
  *                                                              *
  *                      6. Field QBGAGG, the GETPAGES of        *
  *                      the total GROUP BUFFER POOL block       *
  *                      is always 0.                            *
  *                                                              *
  *                      7. In case of DDF/RRSAF rollup          *
  *                      data the rolled up package              *
  *                      is named 'BLANK'.                       *
  *                                                              *
  *                      8. Message FPEA4536I or                 *
  *                      FPEA4537I might be thrown for           *
  *                      data created on a DB2 subsystem         *
  *                      which has installed the PTF for         *
  *                      Apar PK28561.                           *
  *                                                              *
  *                      9. Data for a package might be          *
  *                      missing or calculated invalidly         *
  *                      in case of a long package name.         *
  *                                                              *
  *                      10.                                     *
  *                      A -                                     *
  *                      "L-locks propagated to XES (%)"         *
  *                      field of the  Statistics  Details/Data  *
  *                      Sharing   Locking  window  of           *
  *                      Performance Expert client shows         *
  *                      '******' for  negative values.          *
  *                      B -                                     *
  *                      The same issue concerning               *
  *                      Omegamon Server on host in Batch        *
  *                      Statistics and Accounting report,       *
  *                      trace output.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• 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. 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.
  
  4. In case of DDF/RRSAF rollup data field ASOCCURS shows the
  number accounting intervals rolled up in a record.
  
  5. In case of DDF/RRSAF rollup data field ADTOTPOC shows the
  number of accounting intervals rolled up in a record.
  
  6. GETPAGES of the total GROUP BUFFER POOL shows now the
  accumulated value.
  
  7. In case of DDF/RRSAF rollup data the rolled up package is
  named *ROLLUP*.
  8. The messages will not be thrown under such conditions.
  
  9. The code has been reworked.
  
  10. The  ratios
  SLLOCRAT = (QTGSLSLM - QTGSLPLK) / QTXALOCK) * 100 and
  ALLOCRAT = (QTGALSLM - QTGALPLK) / QTXALOCK) * 100
  being  displayed on DB2 Performance Expert Workstation Client
  under the "L-locks propagated to XES (%)" label
  now correspondingly replaced by the ratios
  SLLOCRAT = (QTGSLSLM / (QTGSLPLK + QTXALOCK)  * 100 and
  ALLOCRAT = (QTGALSLM / (QTGALPLK + QTXALOCK)  * 100
  under the label "P/L-locks propagated to XES synchronously(%)".
  The new ratios are supposed to be more informative for DB2
  administrators.
  Values being calculated with the aid of the new formulas
  placed in Batch  Statistics report and trace output under the
  label 'P/L-LOCKS XES RATE (%)'
  
  
  KEYWORDS : QWACBSC QWACEJST QWACESC ASOCCURS ADTOTPOC
             GETPAGES QBGAGG ROLLUP FPEA4536I FPEA4537I
             PK28561  ALLOCRAT SLLOCRAT L-LOCKS XES
  

APAR Information

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

  PK31295

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

  UK19512

Modules/Macros

•    DGOABLOG DGOABORD DGOABORE DGOABSGE DGOABSPK
  DGOACALC DGOACALX DGOACMER DGOACOMP DGOACREC DGOADIST DGOADSGE
  DGOADSPK DGOAEXIT DGOAEX20 DGOAFGEN DGOAFPCK DGOAIREC DGOAMTRC
  DGOAPARC DGOAREDB DGOAREDC DGOAREDD DGOAREDG DGOAREDM DGOAREDP
  DGOAREDR DGOAREDX DGOARXIT 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 DGOBSRBN DGOBSRCM
  DGOBSRDD DGOBSRLG DGOBSRLK DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP
  DGOBSRRI DGOBSRSH DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTBN
  DGOBSTCM DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO
  DGOBSTQP DGOBSTRI DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM
  DGOFECAL DGOFECA2 DGOFPCAL DGOFPDAT DGOFPDPM DGOFPETD DGOFPE15
  DGOFPE35 DGOFPINT DGOFPRF0 DGOFPRIC DGOFPRPT DGOFPTRM DGOFP000
  DGOFUCAL DGOMEFTA DGOMEGTM DGOMENAB DGOMEXA0 DGOMEXSS DGOMEXST
  DGOMTADJ DGOMTLST DGOMTPKG DGOMTPOP DGORAEXT DGORIREP DGORPACC
  DGORUACC DGORZREP DGOSBLKX DGOSBORD DGOSBORE DGOVSADJ DGOVSCNT
  DGOVSCS2 DGOVSCT1 DGOVSCT2 DGOVUINI FPEMMEND FPEUCBPR FPEUFLNS
  FPEUFLN2 FPEUIFCI FPEUIFC2 FPEUNIDT
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK19512

     UP06/11/14 P F611

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.