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

DB2 MIGHT ABEND WHEN EXECUTING A QUERY WITH AN EQUALITY PREDICATE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Under rare scenarios, DB2 might abend if the following 
conditions are true: 
1) The query contains one or more comparison predicate(s) in the 
form of Substr(c1, 1, <a_constant>) <relop> <a_constant> where 
<relop> can be =, <>, >=, >, <, <=. 
2) The column c1 of predicate 1) is derived from subquery such 
that its outmost operator is either UNION ALL or GROUP BY. 
3) The subquery of 2) has an output column invovled in an 
equality join predicate. 
 
 
Error: 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Incorrect 
index: size = 
64 ix = -108.".)  SQLSTATE=58004 
 
Stack trace: 
 
sqlzeDump 
sqlzeSqlCode 
sqlno_add_to_set 
sqlno_assign_after_prds 
sqlno_assign_walk_quns_and_ff 
sqlno_each_opr 
sqlno_assign_walk_quns_and_ff
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Manually re-write the query by adding an empty string        * 
* literal                                                      * 
* using concatenation.                                         * 
****************************************************************
Local-Fix:
Manually re-write the query by adding an empty string literal 
using concatenation. 
 
change   WHERE  (Substr(t1.c1, 1, 3) = 'CONTANT') 
to 
   WHERE  ( '' + Substr(t1.c1, 1, 3) = 'CONSTANT')
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.03.2015
21.10.2015
21.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.11 FixList