|
Problem IT03737
|
Status: Closed |
SQL0901 IN SQLRIMERGESTREAM WHEN QUERY HAS MULTIPLE DISTINCT CLAUSES |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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
---------------- |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Unix, Linux, HP-UX, Solaris. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 10.1FP5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.08.2014
24.07.2015
27.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
