The sbspace

An sbspace is a logical storage area that contains one or more chunks and stores only smart large objects.

The sbspace can contain the following parts:
  • A metadata area
    The database server writes the following information to the metadata area of an sbspace:
    • Internal information that helps the smart-large-object optimizer manage the data efficiently
    • Storage characteristics for the smart large object
    • Status information for the smart large object
  • A user-data area

    User applications write smart-large-object data to the user-data area of an sbspace.

In Parts of a smart large object, the sbspace1_100 sbspace holds the actual employee image that the LO handle identifies.

The onspaces database utility creates and drops sbspaces for the database server.
Important: Smart large objects can only be stored in sbspaces. They cannot be stored in dbspaces. You must create an sbspace before you attempt to insert smart large objects into the database.