DB2 - Problembeschreibung
Problem IT01542 | Status: Geschlossen |
QUERY CONTAINING CONSTANT BEFORE OLAP FUNCTION MAY FAIL WITH -901: UNEXPECTED NULL ZVALUE OR ABEND WITH SEGV IN SQLRISET | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix * * Pack 4) or higher. * **************************************************************** | |
Local-Fix: | |
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; | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4). | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.05.2014 13.10.2014 13.10.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |