PH40970: OMPE SQLACTIVITY REPORT NOT CREATED WHEN FILTERING ON DB2ID BSQL: SAVED_DPM0 COPIED INCORRECTLY ON INEX PROCESSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OMPE SQLACTIVITY REPORT not created when filtering on DB2ID
  BSQL: saved_dpm0 copied incorrectly on INEX processing
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Batch SQL Activity report set       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Empty reports are generated when        *
  *                      INCLUDE filtering is used.              *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Internal record structures were copied improperly during the
  include/exclude filtering phase.
  

Problem conclusion

• Copying routine corrected. Reports are being generated as
  expected.
  
  Keywords: DB2PM BSQL SQLactivity BATCH
  

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:

Modules/Macros

• DGORINEX KD5AGENT KDPPLEX  KO2APCL2 KO2APCLK KO2APCLS KO2HWLMB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI77805

     UP21/10/28 P F110

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.