DB2 FOR LUW / DB2FORLUW / A10 - DB2

REFRESH TABLE/SET INTEGRITY FOR <table> IMMEDIATE CHECKED may 
return SQL204N when 
the following sequence of events has occurred earlier: 
 
1. <table> was originally created when CURRENT SCHEMA was set to 
a schema-name <schemaA>. 
2. CURRENT SCHEMA was then changed to another schema-name 
<schemaB>. 
3. <table> was then altered from a base table into an MQT using 
ALTER TABLE ... ADD QUERY (<MQT definition query>) 
4. <MQT definition query> mentioned in #3 references an 
unqualified table <base>. 
5. The table <schemaB>.<base> exists, but not <schemaA>.<base> 
 
Note: For #1, <table> could be initially created as a base 
table, or as an MQT that was subsequently altered into a base 
table 
 
Example: 
set current schema a; 
create table b.base (a int not null primary key, b int ); 
create table a.mqt (a int not null, b int); 
set current schema b; 
alter table a.mqt add query (select * from base where a between 
1 and 10) data initially deferred refresh immediate; 
-- The following SET INTEGRITY statement returns SQL204N 
set integrity for a.mqt immediate checked;

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 10.1                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 FixPack 1.                           * 
****************************************************************

Specify fully qualified object names in ALTER TABLE ... ADD 
QUERY <MQT definition query> 
 
Example: 
alter table a.mqt drop query; 
alter table a.mqt add query (select * from b.base where a 
between 1 and 10) data initially deferred refresh immediate; 
set integrity for a.mqt immediate checked;

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.1 FixPack 1.

not known / see Local fix

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

14.06.2012
03.11.2012
03.11.2012