DB2 FOR LUW / DB2FORLUW / A10 - DB2

In the query that has multiple distinct clauses, and we have a 
group by sub-query feeding multiple distinct outer query, we 
could fail with one of these SQL0901N errors: 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "assert-901: (subRC == ((((((sqlzRc)(0 << 24))) | 
(1) | 
((sqlzRc)(0x800".)  SQLSTATE=58004 
or 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "assert-901: (firstStream && allStreams) 
line=7780 
file=sqlri_misc.C".)  SQLSTATE=58004 
 
Stack will be similar to: 
CALLSTCK: 
  [0] 0x000007FEF937130F pdLogPrintf + 0x37F 
  [1] 0x000007FEF51BEC1F sqlri_failed_assertion + 0x8F 
  [2] 0x000007FEF51BFC90 sqlriMergeStream + 0x3D0 
  [3] 0x000007FEF51B2722 sqlriSectInvoke + 0x1F2 
  [4] 0x000007FEF4E84FB2 sqlrr_process_fetch_request + 0x1A2 
----------------

**************************************************************** 
* USERS AFFECTED:                                              * 
* Unix, Linux, HP-UX, Solaris.                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 10.1FP5                                        * 
****************************************************************

First fixed in DB2 Version 10.1 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

12.08.2014
24.07.2015
27.07.2015