home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC89621 Status: Geschlossen

QUERY COMPILATION SHOULD RETURN SQL0418N IF IT HAS UNTYPED GROUPING SETS
COLUMN

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9                        * 
****************************************************************
Local-Fix:
Cast untyped null or parameter marker to type char (1). For 
example, replace NULL with CAST(NULL AS CHAR(1)).
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC96295 IC96347 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.01.2013
18.12.2013
18.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList