Disk layout for sbspaces

You create sbspaces on separate disks from the table with which the data is associated. You can store smart large objects associated with different tables within the same sbspace. When you store smart large objects in an sbspace on a separate disk from the table with which it is associated, the database server provides some performance advantages.

These performance advantages are:
  • You have parallel access to the table and smart large objects.
  • When you choose not to log the data in an sbspace, you reduce logging I/O activity for logged databases.

To create an sbspace, use the onspaces utility. You assign smart large objects to an sbspace when you use the CREATE TABLE statement to create the tables with which the smart large objects are associated.

Copyright© 2018 HCL Technologies Limited