DB2 FOR LUW / DB2FORLUW / 970 - DB2

Diagnostic message EXP0059W will be logged to inform the 
statistical view can not be used for the query: 
 
-- statistical view definition 
create view sv as (select * from ta where a1 in (select b1 from 
tb)); 
-- query to be explained 
select * from ta where a1 in (select b1 from  tb); 
 
-- EXP0059W is dumped to indicate statistical view can not be 
used. 
EXP0059W  The following MQT or statistical view was 
  not eligible because of one or more of the 
 following reasons: (1) the MQT had extra table 
joins or GROUP BY columns that were not present in 
the query, or (2) the query had an SQL construct 
such as ORDER BY, FETCH FIRST n ROWS, DISTINCT, or 
had a subquery that could not be matched:

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A EXP0059W  warning was not generated                        * 
*                                                              * 
* After support for select distinct in Cobra EXP0059W is not   * 
* issued for some statviews:                                   * 
*                                                              * 
* create table ta (a1 int, a2 int);                            * 
* create table tb (b1 int, b2 int);                            * 
* create view sv as (select * from ta where a1 in (select b1   * 
* from tb));                                                   * 
* alter view sv enable query optimization;                     * 
* explain plan for select * from ta where a1 in (select b1     * 
* from tb)                                                     * 
*                                                              * 
*                                                              * 
* Prior to V9.7, the following warning message is logged for   * 
* the GB statview matching failure:                            * 
* Diagnostic Details:  EXP0059W  The following MQT or          * 
* statistical view was                                         * 
*    not eligible because of one or more of the                * 
*    following reasons: (1) the MQT had extra table            * 
*    joins or GROUP BY columns that were not present in        * 
*    the query, or (2) the query had an SQL construct          * 
*    such as ORDER BY, FETCH FIRST n ROWS, DISTINCT, or        * 
*    had a subquery that could not be matched:                 * 
*    "USER"."SV".                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply FP1 if this becomes a serious issue.                   * 
****************************************************************

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in FP1

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.09.2009
22.12.2009
22.12.2009