By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,436 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

Systables lock during REFRESH TABLE causing issues

P: n/a
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?

Thanks,

Craig Wahlmeier

Jan 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.