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 the following performance advantages:

• 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, as your IBM Informix: Dynamic Server Administrator's Reference describes. You assign smart large objects to an sbspace when you create the tables with which the smart large objects are associated. For more information on the SQL statement CREATE TABLE, see the IBM Informix: Guide to SQL Syntax.