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.
About this task
Procedure
To separate row pages from blobpages within a dbspace:
- Load the entire table with rows in which the simple-large-object columns are null.
- Create all indexes.The row pages and the index pages are now contiguous.
- 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.