Connecting Tech Pros Worldwide Forums | Help | Site Map

MQT in DB2 V9.1

Newbie
 
Join Date: Oct 2009
Posts: 4
#1: Oct 16 '09
Hi,

Since yesterday i am unable figure out the solution for one of the issue found while creating the MQT with incremental refresh..these are the details of the error.

step1 : CREATE TABLE P_POLICY AS
( SELECT * FROM S_P_POLICY )
DATA INITALLY DEFERRED
REFRESH DEFERRED;
It is Successfully Created......
Note : Here the source table S_P_POLICY is the nickname of the table in other database of the same system.

step2 : CREATE TABLE STG_P_POLICY FOR P_POLICY PROPAGATE IMMEDIATE;

Here i tried to create stage table for the above MQT...

After running the above statement i found the error

SQL20058N The fullselect specified for the materialized query table P_POLICY is not valid Reason Code = 7

Can any one please help me out to come out of this issue...

Thanks,
Siva

Reply