PK20548: BPA: PERFORMANCE IMPROVEMENT FOR BPD FILE GENERATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using a trace from a system with activity on a large number of
  active tablespaces and indexes, the BPD file generation takes
  a long tike to complete.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 -   Buffer Pool Analyzer                     *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: BPD file generation requires            *
  *                      an unexpected high CPU time             *
  *                      with some trace files.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• If a user only requires a BPD file but no detail reports please
  make use of the new subcommand:
  FILE   LEVEL(SUMMARY).
  In some cases this subcommand can result in much shorter
  processing times.
  ---------------
  SYSMOD TITLE:  BPA Performance
  KEYWORDS:   LEVEL(SUMMARY)
  

Temporary fix

Comments

APAR Information

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

  PK16120

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

  UK14050

Modules/Macros

•    BPOQACHP BPOQAEOF BPOQAEXT BPOQALVP BPOQAPVA
  BPOQARDT BPOQARFL BPOQASCD BPOQCREC BPOQCREP BPOQECHP BPOQEDTL
  BPOQELVP BPOQERDT BPOQERFL BPOQFCAT BPOQFCBU BPOQFCCA BPOQFCDT
  BPOQFCGB BPOQFHOB BPOQFWAT BPOQFWBU BPOQFWCA BPOQFWGB BPOQFWOB
  BPOQINEX BPOQIREC BPOQIREP BPOQRHDT BPOQRHGT BPOQRHOB BPOQRHST
  BPOQRIOA BPOQRPDT BPOQRPGT BPOQRPLN BPOQRPOB BPOQRPST BPOQRUDT
  BPOQRUGT BPOQRULN BPOQRUOB BPOQRUST BPOQSHAT BPOQSHCA BPOQSHGB
  BPOQSRGB BPOQSUGB BPOQTPFA BPOQTPFC BPOQTPFG BPOQXDTL BPOQXHGT
  BPOQXPFA BPOQZREC DGOACMER DGOACREC DGOAFGEN DGOAFILE DGOAIREC
  DGOFPCRS DGOFPNMP DGOFPRPC DGOLAEOF DGOLCREC DGOLFILE DGONCREC
  DGONFILE DGOSCREC DGOSDLTD DGOSFILE DGOSG2X2 DGOSI199 DGOSI202
  DGOSI225 DGOWCREC DGOWFILE DGOW1FIL DGOXCREC DGOXFSQL DGOXF000
  DGOXF001 DGOXF002 DGOXF003 DGOXF004 DGOXF005 DGOXF006 DGOXF007
  DGOXF008 DGOXIREC FPECQECO FPECVCOL FPECVCRS FPECVDDO FPECVDSO
  FPECVEXO FPECVGOL FPECVGSL FPECVKDC FPECVLAO FPECVLVO FPECVRDT
  FPECVRID FPECVRIN FPECVRPL FPECVRTN FPECVSRD FPECVTYO FPEUFFER
  FPEUFFE2 FPEUFIOI FPEUFIO2 FPEUFOCR FPEUFOC2 FPEUFUIS FPEUFUIT
  FPEUFUNI FPEUFUN2 FPEUFWMG FPEUFWMX FPEUFYDY FPEUFYD2 FPEUFYLD
  FPEUFYST FPEUFYS2 FPEUIFCI FPEUIFC2 FPEUMSGS
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK14050

     UP06/05/04 P F605

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.