User has tried to drop a table WF50PP.FACT_EMPLYEE_RCPNT that had 4 mqt's dependant on it.
(WF50PP.AGGR_EMPLYR_ADDR_CNT.
WF50PP.AGGR_EMPLYR_ADDR_TOT,
WF50PP.AGGR_EMPLYR_CNT,
WF50PP.AGGR_EMPLYR_TOT)
All mqt's got rebuilt but not refreshed as part of the script.(MQT's got empty)
Missing REFRESH command
STATUS
Waiting for a fix with CR100,801 on a future release of Toad for DB2.
WORKAROUND:
Verify script before submitting. Just add refresh at the end of each MQT.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center