PI52557: WHEN MONITORING SQL STATEMENTS FROM OPTIM PERFORMANCE MANAGER, THE INFORMATION FOR ACCELERATED STATEMENTS MAY BE MISSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Processing of dsect 2 for ifcid 316 or ifcid 401 is not correct.
  As a result the statement level metrics for accelerated
  statements is not returned at all or only partially.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PE Server subtask                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When monitoring SQL statements from     *
  *                      Optim Performance Manager, the          *
  *                      statement level metrics for accelerated *
  *                      statements are not displayed at all     *
  *                      or displayed only partially.            *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The order of IFCIDs as returned from DB2 to the PE Server
  subtask has effect on the processing of data section 2 for
  IFCID 316 and IFCID 401. As a result the statement level
  metrics for accelerated statements are not returned to the
  requesting interface at all or returned only partially.
  
  PROBLEM CONCLUSION:
  The code has been corrected accordingly.
  
  KEYWORDS:
  OPM SQL DASHBOARD EXTENDED INSIGHT IDAA ACCELERATOR
  ANALYTICS STATEMENT LEVEL METRICS ACCELERATED
  

Problem conclusion

• The code has been corrected accordingly.
  

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:

  UI33911

Modules/Macros

• DGOVMSTR DGOVSCNT
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI33911

     UP15/12/19 P F512

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.