PI94453: IMPROVE VOLUME ANALYSIS WHEN PROCESSING INDEXES ON TABLES IN A TABLESPACE DEFINED WITH LARGE OR DSSSIZE OPTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HIGH CPU IN TCB KO2EVLAB WHEN RUNNING OBJECT ANALYSIS WITH LARGE
  NUMBER OF PDS'S DEFINED WITH THE LARGE OR DSSIZE IN DB2 STC
  .
  Keywords:  volume analysis INDEXES tables tablespaces
             dsssize high cpu
  .
  High CPU time in TCB KO2EVLAB when running Object Anal
  a large number of partitioned datasets defined with th
  DSSISZE attribute allocated in the DB2 address space.
  .
  v540 OMPE customer is reporting threefold increase in CPU usage
  after migrating from v530 OMPE to v540 OMPE even after stopping
  near term history and object analysis, the high CPU persists.
  
  KO2E3052E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM users of       *
  *                 component                                    *
  *                   Object Analysis                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Increased TCB CPU TIME in KO2EVLABTCB   *
  *                      in V540                                 *
  *                                                              *
  *                      Db2 V12 Prefetch collection not         *
  *                      established, MSGKO2E3052E is displayed  *
  *                      at Object Analysis Initialization       *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Logic error resulted in overly aggressive data collection of
  volume data when Object Analysis is started in V540.
  Prefetch data detection was incorrect.
  

Problem conclusion

• Reduce frequency of data collection.
  Correct Prefetch data detection logic.
  

Temporary fix

Comments

APAR Information

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

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

  UI56980

Modules/Macros

•    KO2EOJSK KO2EOJSS KO2EOJS2 KO2EVLSK KO2EVLSS
  KO2EVLS2 KO2XBPSK KO2XBPSS KO2XBPS2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI56980

     UP18/07/03 P F807

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.