DB2 FOR LUW / DB2FORLUW / A50 - DB2

If a query has grouping sets and any group-by column in the 
grouping sets is a untyped null or parameter marker, the query 
compilation should return error SQL0418N. 
 
Without this fix, query compilation may fail with the following 
dumped into db2diag: 
 
2012-12-26-14.30.52.720355-300 E3002681E1454       LEVEL: Info 
(Origin) 
PID     : 10202                TID  : 46917589395776PROC : 
db2sysc 1 
INSTANCE: XXXXXXXX             NODE : 001          DB   : XXXXX 
APPHDL  : 1-19111              APPID: 
144.14.11.203.4421.121224160222 
AUTHID  : XXXXX 
EDUID   : 560                  EDUNAME: db2agent (XXXXX) 1 
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 
MESSAGE : ZRC=0x80310025=-2144272347=SQLNN_E_BAD 
          "unexpected error and state is bad" 
DATA #1 : String, 62 bytes 
An unexpected error was detected during statement compilation. 
DATA #2 : Boolean, 1 bytes 
true 
DATA #3 : Boolean, 1 bytes 
false 
DATA #4 : Boolean, 1 bytes 
false 
DATA #5 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 21 
 sqlerrmc: invalid qnc assigment 
 sqlerrp : SQLNQ085 
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFF9C      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
DATA #6 : String, 286 bytes 
Compiler error stack for rc = -2144272347: 
sqlnn_cmpl[370] 
sqlnr_exe[1180] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_prep4_action[11025] 
sqlnq_expand_rollup[200] 
sqlnr_cube2union[300] 
sqlnr_cr8_grouping_set_box[110] 
sqlnr_grouping_item_mappin[300] 
sqlnq_pid::replace_qnc[100] 
 
Stack dump is similar to the following: 
 
ossDumpStackTraceEx 
OSSTrapFile::dumpEx 
sqlo_trce 
sqloDumpDiagInfoHandler 
pthread_kill 
sqloDumpEDU 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeSqlCode 
sqlnn_erds 
sqlnq_pid::replace_qnc 
sqlnr_grouping_item_mapping 
sqlnr_cr8_grouping_set_box 
sqlnr_cube2union 
sqlnq_expand_rollup 
sqlnr_prep4_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
sqljs_ddm_prpsqlstt 
sqljsParseRdbAccessed 
sqljsParse 
sqljsDrdaAsDriver 
sqeAgent::RunEDU() 
sqzEDUObj::EDUDriver() 
sqlzRunEDU 
sqloEDUEntry 
clone

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.4.                             * 
****************************************************************

Cast untyped null or parameter marker to type char (1). For 
example, replace NULL with CAST(NULL AS CHAR(1)).

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

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

26.09.2013
15.09.2014
15.09.2014