Hi,
We have a table with 2 columns, one of which is a 2Mb CLOB column. We have
defined the table in a tablespace with 4K pagesize, and the LONG IN a DMS
tablespace with a pagesize 4k extentsize 32 prefetchsize 96, in a 4K
bufferpool. This was as per recommendations from IBM (we had a conference
call with them).
Perhaps you could use the same for your BLOB column.
Regards,
Abhijit
-----Original Message-----
From: Villa Horacio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 5:10 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Page size
Hi,
I'm going to define a Long tablespace to hold blob objects (I have a
blob(256 k) column).
What page size should I use?
Regards,
Horacio Villa
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
