Initially I thought that 32K would be best for large objects, but one interesting thing that I discovered is that if you have a table with regular data on a 4K page and long data on a 32K page (or if the sizes are different), and you try and reorg the table, you cannot use a temporary tablespace to reorg the data if you attempt to also reorg the LOB's at the same time (the reorg must use free space within the existing tablespaces for work area during the reorg).
Last edited by Marcus_A; 07-26-06 at 13:42.
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390