DB2 FOR LUW / DB2FORLUW / A50 - DB2

The specific steps to encounter this error are : 
 
connect to sample 
create table user1.foo like staff 
 
set schema user1 
create view v1 as select id,name from foo 
terminate 
 
set schema user2 
alter view user1.v1 enable query optimization 
select count(*) from user.v1 
 
The last SELECT statement will return the error 
 
SQL0204N  "USER2.FOO" is an undefined name.  SQLSTATE=42704 
 
and invalidate the view USER1.V1. To resolve the problem the 
view should be recreated.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using view enabled for optimization.                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 FP7                              * 
****************************************************************

Option 1: Fully qualify the table names in the view 
- recreate the statistical view in which the tables are 
referenced using fully qualified names. 
- subsequent ALTER VIEW ... ENABLE QUERY OPTIMIZATION statements 
can be performed under any schema name. 
 
Option 2: 
- recreate the statistical view as-is; i.e., some tables in the 
view are referenced without fully qualified names 
- subsequent ALTER VIEW ... ENABLE QUERY OPTIMIZATION statements 
must be performed under the original schema to avoid 
encountering the issue again. 
   Example: 
     set schema user1 
     alter view user1.v1 enable query optimization 
 
Options 1 is recommended.

Upgrade to DB2 version 10.5 FP7

not known / see Local fix

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

18.02.2015
19.01.2016
19.01.2016