DB2 FOR LUW / DB2FORLUW / 970 - DB2

When there is an expression in the form of 
 
COALESCE(<expr1>, <literal>) 
 
in a SELECT clause and the correspondent GROUP BY clause 
contains only the expression <expr1>, 
 
in an database partition feature (DPF) environment, such a SQL 
statement may experience an non-severe system error SQL0901N 
with the following log in db2diag.log file. 
 
FUNCTION: DB2 UDB, table Q services, sqlkt_pack_tuple, probe:30 
MESSAGE : DIA0001E An internal error occurred. Report the 
following error code 
          : "Line=02428, rc1=0x82170001, rc2=0x00000000, rc3=0, 
          msg=cold=NULLABLE zvalue=NONULLS col(9)". 
 
Note that VALUE is a synonym of COALESCE.

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users in an database partition feature (DPF) environment * 
* running a query with expressions using COALESCE or VALUE in  * 
* a SELECT clause                                              * 
* with GROUP BY.                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* same as "Error Description"                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 4                            * 
****************************************************************

Change the SQL statement to have the GROUP BY clause the same 
expression as in the SELECT clause.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 4

refer to "Local Fix"

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.11.2010
02.05.2011
02.05.2011

9.7.FP4