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

QUERY COMPILER RETURNS -901 WITH ERROR MESSAGE "HAD TROUBLES WHILE
REMOVING AN UNREFERENCED QCL."

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
If a query contains content like 'T1 LEFT OUTER JOIN T2 WHERE 
T2.COL IS NULL', the query compiler may return -901 error like 
below: 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Had 
troubles while 
removing an unreferenced QCL.".)  SQLSTATE=58004 
 
When the error is hit, the compiler error stack will be logged 
in db2diag.log like the following: 
 
Compiler error stack for rc = -2144272298: 
 
sqlnn_cmpl[370] 
 
sqlnr_exe[1200] 
 
sqlnr_rcc[100] 
 
sqlnr_seq[100] 
 
sqlnr_comp[110] 
 
sqlnr_optprep_action[100] 
 
sqlnr_optprep[125] 
 
sqlnr_Manual2NativeAJ[85]
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.5 users                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5FP9                                       * 
****************************************************************
Local-Fix:
db2set DB2_ANTIJOIN=NO
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fix in DB2 V9.5FP9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.11.2011
28.03.2012
28.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList