Estimating tblspace pages for simple large objects

In your estimate of the space required for a table, include blobpages for any simple large objects that are to be stored in that tblspace. For a table that is both relatively small and nonvolatile, you can achieve the effect of a dedicated blobspace by separating row pages and blobpages.

To separate row pages from blobpages within a dbspace:

  1. Load the entire table with rows in which the simple-large-object columns are null.
  2. Create all indexes. The row pages and the index pages are now contiguous.
  3. Update all the rows to install the simple large objects. The blobpages now appear after the pages of row and index data within the tblspace.

Copyright© 2018 HCL Technologies Limited