PI47383: INCORRECT DATA IS SHOWN IN TEP FOR QUERIES CONTAINING GROUP BY AND COUNT CLAUSES FOR DB2PLEX RELATED ATTRIBUTE GROUPS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Query containing Group by and Count clauses may return incorrect
  data when issued against DB2Plex related attribute groups
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - TEMA / TEMS                                *
  *                 - TEP                                        *
  *                 - Enhanced 3270 UI                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: INCORRECT DATA IS SHOWN IN TEP FOR      *
  *                      QUERIES CONTAINING GROUP BY AND COUNT   *
  *                      CLAUSES FOR DB2PLEX RELATED ATTRIBUTE   *
  *                      GROUPS.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The number of data rows was cleared incorrectly, and internal
  control structures were processed inefficiently.
  
  PROBLEM CONCLUSION:
  Count number of data rows properly and process internal control
  structures more efficiently.
  
  KEYWORDS:
  INCORROUT OBJECT ANALYSIS PLEX DB2PLEX GROUPBY COUNT
  

Problem conclusion

• Count number of data rows properly and process internal control
  structures more efficiently.
  

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:

  UI33309 UI33310

Modules/Macros

• KDPPLEX
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R520 PSY UI33309

     UP15/12/01 P F511

• R530 PSY UI33310

     UP15/12/01 P F511

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.