PK27918: MASS DELETE NUMBER IN SQL ACTIVITY REPORT IS OBSOLETE

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• We are inserting one row in a Declared Global Temporary Table
  and in the Workload Hilite of the SQLACTIVITY trace we see a
  very high number of pages and rows processed for this insert.
  

Local fix

• no fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 _   OMEGAMON Server                          *
  *                 _   Tivoli Enterprise Monitoring Agent       *
  *                 _   Classic Interface                        *
  *                 _   ISPF Monitoring dialogs                  *
  *                 _   Performance Expert Client                *
  *                 _   Performance Expert Agent for             *
  *                     DB2 Connect Monitoring                   *
  *                 _   Buffer Pool Analyzer                     *
  *                 _   EXPLAIN                                  *
  *                 s   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The MASS DELETES column in the Scan     *
  *                      Activity reports of SQL Activity        *
  *                      always shows the same values as the     *
  *                      SCANS columns.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The MASS DELETES column has been removed
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

  PK27575

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

  UK16367 PK42618

Modules/Macros

•    DGORPSCA
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK16367

     UP06/07/23 P F607

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.