Sbpages

An sbpage is the type of page that the database server uses to store smart large objects within a sbspace. For a description of sbspaces, refer to Sbspaces. Unlike blobpages, sbpages are not configurable. An sbpage is the same size as the database server page, which is usually 2 kilobytes on UNIX and 4 kilobytes on Windows.

The unit of allocation in an sbspace is an extent, whereas the unit of allocation in a blobspace is a blobpage. Just as with pages in a chunk, a certain number of smart large object extents compose a chunk in an sbspace, as Figure 38 illustrates. An extent is always entirely contained in a chunk and cannot cross chunk boundaries.

Figure 38. A Chunk in an Sbspace, Logically Separated into a Series of Extents

Smart large objects cannot be stored in a dbspace or blobspace. For more information, see Sbspaces, and sbspace structure in the disk structures and storage chapter of the IBM Informix Dynamic Server Administrator's Reference.

The database server calculates the extent size for a smart large object from a set of heuristics, such as the number of bytes in a write operation. For more information, see Extent Sizes for Sbspaces.