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
|