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 IC81208 Status: Geschlossen

SQL STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC
ASSIGMENT")

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
An SQL stmt like this 
SELECT     B.ID_LOAN_SYST_GEND, B.AMT_FINL_ITEM, 
B.CD_FINL_ITEM FROM   <tablename> A inner join    <tablename> B 
on A.<col_name> =  B.<col_name> AND B.<col_name> <> 'Y' AND 
B.<col_name> = '9999-01-01-00.00.00.000000' where B.<col_name> = 
(SELECT MIN(C.<colname>) FROM <table_name> C WHERE A.<col_name> 
=  C.<col_name> AND C.<col_name> <> 'Y' AND C.<col_name> = 
'9999-01-01-00.00.00.000000' and nodenumber(C.<col_name>)= 
current node) and nodenumber(B. <col_name>= current node and 
nodenumber(A.<col_name>)= current node 
 
in a DPF env. 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "invalid 
qnc assigment".) 
SQLSTATE=58004 
 
and has the following stack trace info in the trap file 
generated in the FODC_App_Err_<timestmp> 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000000B5E7D0 pthread_kill + 0xB0 
0x0900000004C60B2C sqloDumpEDU + 0xA8 
0x0900000004AE1A2C sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 
0x100 
0x0900000004AE2ED4 
sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2@glue5BA + 0x98 
0x0900000003BE2338 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x36C 
0x09000000079A86E8 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28 
0x09000000079A900C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 
0x144 
0x09000000079A8E1C sqlnn_erds__FiN41e + 0x154 
0x0900000004B96954 sqlnn_erds__FiN41e@glue711 + 0xC0 
0x09000000046F4604 
replace_qnc__9sqlnq_pidFP9sqlnq_qnc15sqlnq_typeCheck + 0x440 
0x09000000069C1C68 
qun_update__9sqlnq_pidFPP9sqlnq_qunT1iP12sqlnq_colmap15sqlnq_typ 
eCheckT3 + 0x5E8 
0x0900000006902454 
qun_update__9sqlnq_pidFPP9sqlnq_qunT1iP12sqlnq_colmap15sqlnq_typ 
eCheckT3@glueACE + 0x80 
0x0900000004702ADC 
sqlnq_pt_qun_upd_all_exps__FPP9sqlnq_qunT1iP12sqlnq_colmapPFP9sq 
lnq_expP9sqlnq_qtb_iPiP3locT3 + 0x274 
0x0900000006944F70 
sqlnr_sqo_byScalar_action__FP9sqlnq_oprP9sqlnq_qunR17sqlnq_prdEl 
emListN21R17sqlnq_qncElemListR17sqlnq_qtbElemListP9sqlnq_qtbRiP3 
loc + 0xC8 
0x090000000692A7C8 sqlnr_qrwprep_phase2__FP3locPi + 0x2E8 
0x09000000078A37B8 
sqlnr_prep2_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x84 
0x09000000078B2784 
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres 
s@AF575_341 + 0x178 
0x09000000078B2390 
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 
0xF4 
0x09000000078B2220 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress 
+ 0x84 
0x09000000078B12A8 sqlnr_exe__FP9sqlnq_qur + 0x3F0 
0x09000000078B0944 sqlnr_exe__FP9sqlnq_qur@glue15DE + 0xA4 
0x09000000078C6E64 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur + 0x1E4 
0x09000000079F1534 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env + 0x40 
0x09000000078EA974 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ 
LOCK_INFOP16sqlra_cached_varPiPUl + 0x7C4 
0x09000000078E9824 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x648 
0x0900000007BE1704 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x608 
0x0900000004FFEC58 
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x2B8 
0x09000000057097E0 
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x3E0 
0x09000000048C754C 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x8 
0x0900000007B60F04 
.sqljsParse.fdpr.clone.212__FP13sqljsDrdaAsCbP14db2UCinterfaceP8 
sqeAgentb + 0x2BC 
0x0900000007AB22C0 @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0xAE0 
0x0900000007954B54 
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA0 
0x0900000003C2B3E8 
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x310 
0x090000000795432C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0xEC 
0x09000000079D8CD4 RunEDU__8sqeAgentFv + 0xB4 
0x09000000079D6320 EDUDriver__9sqzEDUObjFv + 0xDC 
0x09000000079D6204 sqlzRunEDU__FPcUi + 0x24 
0x09000000079DF4E4 sqloEDUEntry + 0x264 
</StackTrace>
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 4.                       * 
****************************************************************
Local-Fix:
Run the query at a reduced optimization level of 2.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
First Fixed in Version 9.7 Fix Pack 6.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84451 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.02.2012
13.06.2012
13.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4,
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList