Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: Larage Tablespace

    V8.1 OS AIX.

    I want to create a Larage tablespace to Keep LOBs .
    How do i decide the page size that i should create for this tablespace.?

  2. #2
    Join Date
    May 2003
    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 12: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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts