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

QUERY EXECUTION FAILS WITH -901 REASON "(LIKE: SEARCH PATTERN
STRUCTURE IS NULL)"

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Under certain circumstances a query may fail during execution 
with the following error: 
 
SQL0901N  The SQL statement or command failed because of a 
database system error. (Reason "(LIKE: search pattern structure 
is NULL) ".)  SQLSTATE=58004 
 
This can happen when the query satisfies all of the following: 
 
- The query includes a LIKE predicate or a reference to one of 
the following builtin functions: LOCATE, POSITION, POSSTR, 
INSTR, INSTRB, INSTR2, INSTR4 or LOCATE_IN_STRING 
- The search pattern for the LIKE expression or search string 
for the builtin function above is an expression that includes a 
non-nullable column reference 
- The non-nullable column is also referenced in an equality 
predicate where the other side is a parameter marker or nullable 
host variable 
 
For example, assuming column T2.C1 is not nullable: 
 
SELECT * FROM T1, T2 
WHERE T1.C1 LIKE T2.C1 and T2.C1 = ?
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4                       * 
****************************************************************
Local-Fix:
Replace the parameter marker or host variable with a literal. 
Note that this will only work if the statement concentrator is 
disabled
Lösung
First fixed in Version 10.5 Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.05.2014
17.03.2015
17.03.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList