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

DB2 Logging in Materialised queries

P: 1
Hi,

We have a MQT(Materialised Query Table created from 4 base tables).
The MQT has a option of
data initially deferred refresh deferred
The table actually contains arnd 40Million rows when inserted.
So we are having a problem with the logging as the log space required is too huge.
we cannot use the NOT LOGGED INITIALLY as it applies for only the same unit of work
We are working on DB2 version 8 and need to come over this problem
Any pointers will be appreciated
Sep 5 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.