DB2 FOR LUW / DB2FORLUW / A10 - DB2

Query containing at least one constant, host variable, parameter 
marker or correlated column before OLAP function and column 
aggregation function in SELECT list or HAVING clause may fail 
with: 
SQL0901N  The SQL statement or command failed because of a 
database system error. 
(Reason "unexpected NULL ZValue!".) 
 
or cause SEGV in sqlriset if that query is one of the legs of 
UNION. 
Trap file will contain following function on the top of the 
stack: 
  _Z8sqlrisetP8sqlrr_cb + 0x0260

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 and Fix Pack 4 or higher.        * 
****************************************************************

Reorder SELECT list using OLAP function first. E.g if original 
statement was: 
SELECT 'CONSTANT', ROW_NUMBER() OVER (PARTITION BY 1),[...], 
SUM(COLCOUNT) FROM T1; 
 
rewrite it in following manner: 
SELECT ROW_NUMBER() OVER (PARTITION BY 1), 'CONSTANT', [...] 
SUM(COLCOUNT) FROM T1;

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 10.1 and Fix Pack 4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.03.2014
02.06.2014
02.06.2014