IT06891: COMPLEX QUERY WITH COUNT(DISTINCT ..) AND GROUP BY GENERATES A LOT OF TEMP TABLES/EXTENTS AND RETURNS -229

APAR status

• Closed as program error.

Error description

• Complex query with count(distinct ..) and group by generates a
  lot of temp tables/extents and returns -229.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 12.10.xC1 through 12.10.xC5.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query involving a large number of duplicated aggregate     *
  * functions may result in -229 error if many of these          *
  * functions require DISTINCT and there are many instances of   *
  * such aggregate functions.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6.                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6.
  

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:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RC10 PSN

     UP