Fixes are available
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 number
LI75841
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-13
Closed date
2011-12-08
Last modified date
2011-12-08
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
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021