470,614 Members | 1,584 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Systables lock during REFRESH TABLE causing issues

Suppose you have a table named TAB1. You create two mqt's, MQT1 and
MQT2, that reference TAB1 in their definition. Why is it that while
you issue a REFRESH TABLE MQT1, you cannot issue a DROP TABLE MQT2
without getting a -911?

It appears that the systables row for TAB1 is locked by both the
REFRESH and the DROP commands. What in the world is on the systables
row that needs to be updated by the DROP of a MQT?


Craig Wahlmeier

Jan 4 '07 #1
0 1424

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bruce Pullen | last post: by
9 posts views Thread by kavallin | last post: by
7 posts views Thread by Troels Arvin | last post: by
reply views Thread by Troels Arvin | last post: by
5 posts views Thread by prakashwadhwani | last post: by
6 posts views Thread by michael.spoden | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.