DB2 FOR LUW / DB2FORLUW / A50 - DB2

The execution of a query using DB2 Text Search, 
as in the following example, might be slow: 
 
   SELECT C1, C2 
   FROM T1 
   WHERE CONTAINS ( C3, 'XYZ' ) = 1 
 
You can use the EXPLAIN statement to check the access plan 
generated by the optimizer.  The access plan of this example 
query can be formatted by using db2exfmt and it might look as 
follows if you encounter this problem: 
 
Access Plan: 
----------- 
        Total Cost:             227.412 
        Query Degree:           1 
 
                Rows 
               RETURN 
               (   1) 
                Cost 
                 I/O 
                 | 
                 40 
               ^HSJOIN 
               (   2) 
               226.682 
                 112 
         /-------+--------\ 
      1000                  40 
     TBSCAN               TBSCAN 
     (   3)               (   4) 
     196.917              19.0036 
       112                   0 
       |                    | 
      1000                 1000 
 TABLE: SCHEMA   TABFNC: SYSIBMINTERNAL 
      T1          SYSTS_TEXTSEARCH 
       Q2                   Q1 
 
where the details of TBSCAN(4) will include a residual 
predicate: 
 
                Predicates: 
                ---------- 
                3) Residual Predicate, 
                        Comparison Operator:            Equal 
(=) 
                        Subquery Input Required:        No 
                        Filter Factor:                  0.04 
 
                        Predicate Text: 
                        -------------- 
                        (Q1.$C1 = 1)

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 Fix Pack 3                       * 
****************************************************************

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The issue was first fixed in DB2 version 10.5 Fix Pack 3.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.10.2013
27.02.2014
27.02.2014