Hi All,
I'm working on DB2 UDB 8.2 with Fixpack 10 on Windows 2000 Server.
The problem I'm facing is that I have created a table having BLOB type
column with NOT LOGGED option. (see script below)
CREATE TABLE ATTACHMENTS
(
CASEATTACHMENTID INTEGER NOT NULL,
ATTACHMENTDATA BLOB(2G) NOT LOGGED
) LONG IN "TSLRGOBJ"
The TableSpace has also been created without LOG option.(see Script
below)
CREATE LARGE TABLESPACE TSLRGOBJ
PAGESIZE 32 K
MANAGED BY AUTOMATIC STORAGE
EXTENTSIZE 32
OVERHEAD 10.5
PREFETCHSIZE 32
TRANSFERRATE 0.14
BUFFERPOOL FPI_BUFFPOOL
My Questions are :
1. How can I enable logging for LOB type data without dropping the
table?
2. Are any changes to be made to TableSpace also for the same (againn
without dropping it)?
3. I some articles and posting on the same group I came accross the
info that LOB of size greater than 1G are not logged. Are we talking
about the contents of the LOB column or the size of the column? (in my
case the size of the column is 2G but the file size cannot be greater
than 10MB)
Regards,
Ashish