PM48395: MODIFIED PACKAGE AVERAGE CALCULATION INCORROUT

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Change the package average calculation in Accounting Report to
  total value divided by QPACRLNU
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Averages of package data in Batch    *
  *                      Accounting report are not suitable for  *
  *                      NATIVE SQL PROCEDUREs. Averages PER     *
  *                      THREAD instead of averages PER PACKAGE  *
  *                      SECTION should be calculated and shown  *
  *                      up. QPACRLNU should be used as divisor. *
  *                      2. QPACSQLC, label SQL STMT - AVERAGE   *
  *                      and - TOTAL is N/P in rollup cases.     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Averages of package data in Batch Accounting report are not
  suitable for NATIVE SQL PROCEDUREs.
  2. QPACSQLC, label SQL STMT - AVERAGE and - TOTAL is N/P in
  rollup cases.
  
  PROBLEM CONCLUSION:
  Code has been changed.
  1. Averages PER THREAD instead of averages per package section
  are calculated and shown up in Accounting Reports.
  
  In cases where the number of package sections and the value of
  QPACRLNU are (nearly) identical, the presented averages do not
  differ to reports that were created w/o this fix. This happens
  in most cases. Nevertheless the new calculation may affect
  following data blocks and fields in Batch Accounting Reports:
  
  a. Package Identification
  QPACSQLC
  
  b. Package Times   Class 7
  QPACSCT  ADCPUTP  QPACTJST ADCPCL7T APACC7Z  ADTSUSTP
  ADTCBCL8 ADCPCL8T ADNACL7T APACARNA ADSUCPU7 ADSUTCB7
  ADSUCPP7 ADSUC7Z  ADELCL7L ADTCCL7L ADWTCL7L ADWTCL7T
  c. Package Times   Class 8 - Suspensions
  QPACALOG QPACAWAR QPACAWCL QPACAWDR QPACAWTE QPACAWTI
  AWTPLOLA QPACAWTL QPACAWLH QPACAWTP QPACAWTR QPACAWTW
  QPACAWTG APGCSUST QPACALBW ADTSUSTP
  
  ADALPSSC ADARPSSC ADAWPSSC ADCMPSSC ADDRPSSC ADIOPSSC
  ADLLPSSC ADLBPSSC ADLAPSSC ADLRPSSC ADPGPSSC ADSTPSSC
  ADLMPSSC ADTSUSCP ADGCPSSC ADNOPSSC
  
  d. Package Global Contention L-Locks (Class 8)
  APLKSUST QPACAWTJ QPACAWTK QPACAWTM
  APLKSUSC APLPSUSC APLCSUSC APLOSUSC
  
  e. Package Global Contention P-Locks (Class 8)
  APPLSUST QPACAWTN QPACAWTO QPACAWTQ
  APPLSUSC APPSSUSC APPPSUSC APPOSUSC
  
  f. Package SQL Activity (Class 10)
  APSELEC  APINSRT  APUPDTE  APDELET  APDESC   APPREP
  APOPEN   APFETCH  APCLOSE  APLOCK   APCALL
  g. Package Buffer Pool Activity (Class 10)
  QBACGETP QBACNGTP QBACSWSP QBACIMWP QBACRIOP QBACSEQP
  QBACLPFP QBACDPFP QBACSIOP
  
  h. Package Locking Activity (Class 10)
  ATXATIM  ATXADEA  ATXALES  ATXALEX  ATXANPL  ATXALOCK
  ATXAUNLK ATXAQRY  ATXACHG  ATXAIRLM APLRSUSP ATXASLOC
  ATXASLAT ATXASOTH APDTIMDL APLCLKET
  
  2. A value for QPACSQLC is shown again.
  

Problem conclusion

Temporary fix

Comments

• Code has been changed.
  1. Averages PER THREAD instead of averages per package section
  are calculated and shown up in Accounting Reports.
  
  In cases where the number of package sections and the value of
  QPACRLNU are (nearly) identical, the presented averages do not
  differ to reports that were created w/o this fix. This happens
  in most cases. Nevertheless the new calculation may affect
  following data blocks and fields in Batch Accounting Reports:
  
  a. Package Identification
  QPACSQLC
  
  b. Package Times   Class 7
  QPACSCT  ADCPUTP  QPACTJST ADCPCL7T APACC7Z  ADTSUSTP
  ADTCBCL8 ADCPCL8T ADNACL7T APACARNA ADSUCPU7 ADSUTCB7
  ADSUCPP7 ADSUC7Z  ADELCL7L ADTCCL7L ADWTCL7L ADWTCL7T
  c. Package Times   Class 8 - Suspensions
  QPACALOG QPACAWAR QPACAWCL QPACAWDR QPACAWTE QPACAWTI
  AWTPLOLA QPACAWTL QPACAWLH QPACAWTP QPACAWTR QPACAWTW
  QPACAWTG APGCSUST QPACALBW ADTSUSTP
  
  ADALPSSC ADARPSSC ADAWPSSC ADCMPSSC ADDRPSSC ADIOPSSC
  ADLLPSSC ADLBPSSC ADLAPSSC ADLRPSSC ADPGPSSC ADSTPSSC
  ADLMPSSC ADTSUSCP ADGCPSSC ADNOPSSC
  
  d. Package Global Contention L-Locks (Class 8)
  APLKSUST QPACAWTJ QPACAWTK QPACAWTM
  APLKSUSC APLPSUSC APLCSUSC APLOSUSC
  
  e. Package Global Contention P-Locks (Class 8)
  APPLSUST QPACAWTN QPACAWTO QPACAWTQ
  APPLSUSC APPSSUSC APPPSUSC APPOSUSC
  
  f. Package SQL Activity (Class 10)
  APSELEC  APINSRT  APUPDTE  APDELET  APDESC   APPREP
  APOPEN   APFETCH  APCLOSE  APLOCK   APCALL
  g. Package Buffer Pool Activity (Class 10)
  QBACGETP QBACNGTP QBACSWSP QBACIMWP QBACRIOP QBACSEQP
  QBACLPFP QBACDPFP QBACSIOP
  
  h. Package Locking Activity (Class 10)
  ATXATIM  ATXADEA  ATXALES  ATXALEX  ATXANPL  ATXALOCK
  ATXAUNLK ATXAQRY  ATXACHG  ATXAIRLM APLRSUSP ATXASLOC
  ATXASLAT ATXASOTH APDTIMDL APLCLKET
  
  2. A value for QPACSQLC is shown again.
  
  KEYWORDS : AVERAGES PER THREAD QPACRLNU PACKAGE OCCURRENCE CLASS
  7 8 10 IDENTIFICATION TIMES SUSPENSIONS GLOBAL CONTENTION
  L-LOCKS P-Locks SQL ACTIVITY BUFFER POOL LOCKING
  

APAR Information

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

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

  UK76019

Modules/Macros

• DGOAACUM DGOABORD DGOABORE DGOACALC DGOACMER
  DGOACOMP DGOACREC DGOADIST DGOAEXIT DGOAEX20 DGOAFORM DGOAIREC
  DGOAIREP DGOAMTRC DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG
  DGOAREDI 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 DGOFPRIC DGORAEXT DGORIREP DGORPACC DGORUACC DGORZREP
  FPEUCBPR
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK76019

     UP12/02/10 P F202

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.