LI75841: INSTANCE MAY ABEND COMPILING A QUERY CONTAINING PREDICATES ON MAX OR MIN FUNCTIONS AGGREGATED ON CASE EXPRESSIONS

DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• DB2 instance may abend during compilation of a query that
  satisfies the following conditions:
  - There is an equality predicate (EQPRD) in the query
  - One side of EQPRD is either a constant, host-variable or
  special register (CONST)
  - The other side of EQPRD is a column derived from the output of
  a MAX or MIN aggregate function
  - The MAX or MIN function aggregates a column from a nested
  subselect (NS)
  - The column from NS is a CASE expression (CASEEXP)
  - CASEEXP has only 1 WHEN clause
  - The WHEN clause is also an EQPRD (WHENPRD)
  - One side of WHENPRD is CONST
  - The other side of WHENPRD is non-CONST
  - NS also has another CASE expression as an output column which
  is not referenced anywhere else
  - NS has a SELECT DISTINCT clause
  

Local fix

• Rewrite the problematic query into a semantically identical form
  to preclude any of the conditions described above, e.g., EQPRD
  may be rewritten as a redundant IN predicate.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 9.1 Fix Pack 11 or later.             *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 Version 9.1 Fix Pack 11.
  

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:

  IC75197

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSN

     UP