467,189 Members | 1,264 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

DB2 Logging in Materialised queries

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
  • viewed: 866
Share:

Post your reply

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

Similar topics

5 posts views Thread by Ravi Shankar | last post: by
4 posts views Thread by CK | last post: by
5 posts views Thread by My SQL | last post: by
2 posts views Thread by Ed L. | last post: by
2 posts views Thread by stig erikson | last post: by
reply views Thread by Chrom_ | last post: by
kiss07
30 posts views Thread by kiss07 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.