PK70371: UNUSUALLY HIGH VALUES FOR SQL DML IN DB2PM PE STATISTICS REPORT AND TRACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running PE Statistics report, get unusuall incorrect values for
  SQL DML.  For example: STATISTICS TRACE LAYOUT(LONG)
  
                 DB2 PERFORMANCE EXPERT (V2)
                   STATISTICS TRACE - LONG
  
  ---- HIGHLIGHTS -------------------------------------------
  INTERVAL START: 07/13/08 03:30:02.81
  INTERVAL END  : 07/13/08 03:45:03.56
  INTERVAL ELAPSED: 15:00.747944
  
  SQL DML                 QUANTITY  /SECOND  /THREAD  /COMMIT
  ----------------------  --------  -------  -------  -------
  SELECT                         0     0.00     0.00     0.00
  INSERT                         0     0.00     0.00     0.00
  UPDATE                         0     0.00     0.00     0.00
  DELETE                         0     0.00     0.00     0.00
  PREPARE                 4294967K  4768.2K   226.1M    24.3M
  DESCRIBE                       0     0.00     0.00     0.00
  DESCRIBE TABLE                 0     0.00     0.00     0.00
  OPEN                    4294967K  4768.2K   226.1M    24.3M
  CLOSE                   4294967K  4768.2K   226.1M    24.3M
  FETCH                   4294967K  4768.2K   226.1M    24.3M
  TOTAL                     17180M    19.1M   904.2M    97.1M
  
  The analysis of the data showed that the problem is caused by
  trace records > 32K due to the usage of a high number of Buffer
  pools and Group Buffer Pools.
  Changed code to work with more storage - this helped for Buffer
  Pool sections.
  This APAR will address this so that correct values are shown.
  

Local fix

• No Workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  *                 - Performance Database users                 *
  *                 - Performance Warehouse user                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unusual negative values in Batch        *
  *                      Statistics Trace and Report in data     *
  *                      blocks, i.e. SQL DML, SQL DCL,          *
  *                      or SQL DDL. This may happen with trace  *
  *                      data with a high number of Buffer Pool  *
  *                      or Group Buffer Pool sections.          *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  Use length variable for records greater than 32KB and
  allocate storage greater than 32KB wherever necessary.
  
  PROBLEM CONCLUSION:
  Code has been changed to allow batch Statistics processing
  of trace records with a length greater than 32KB.
  
  KEYWORDS:
  LENGTH GREATER THAN 32KB
  EXTENSIVE USAGE GROUP BUFFER POOLS
  

Problem conclusion

• PROBLEM CONCLUSION:
  Code has been changed to allow batch Statistics processing
  of trace records with a length greater than 32KB.
  
  KEYWORDS:
  LENGTH GREATER THAN 32KB
  EXTENSIVE USAGE GROUP BUFFER POOLS
  

Temporary fix

Comments

APAR Information

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

  PK70325

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

  UK38910 UK38911

Modules/Macros

•    DGOFSDLT DGOSDLTD DGOSPREP DGOSREDC
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK38910

     UP08/08/19 P F808

• R410 PSY UK38911

     UP08/08/19 P F808

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.