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

DB2 MAY BE SUSTAINED IN COMPILATION OF A COMPLICATED SQL WITH LIKE CLAUSE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
A typical trap file may show the following stack trace: 
 
sqlnq_pid11fixed_value 
address: 0x00007FA4743DF010 
sqlnr_pred_like_rewr 
sqlnr_gen_twin_prd 
address: 0x00007FA474334D9C 
sqlnr_optprep_chunk2_action 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
 
3 conditions: 
1) An OR predicate where at least one operand it a LIKE 
predicate 
2) The search-string or pattern-string of the LIKE predicate to 
be based on expression, or on a column from a sub-select or view 
that is based on expression. 
3) The expression from (2) will contain another LIKE predicate 
that either involves all constants. 
 
For example 
 
 where case 
       when 'Run Report' NOT LIKE '%View Report' then c10 
       else v10 
       end like '%abcd%' 
    or c10nn = 'helloabc'
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1fp5                                      * 
****************************************************************
Local-Fix:
N/A
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.01.2015
15.07.2015
15.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList