Testing the access method with an sbspace

An sbspace holds smart large objects for the database server. This space is physically included in the database server configuration.

It is recommended that you store indexes in smart-large objects because the database server protects transaction integrity in sbspaces with rollback and recovery.

To test the access method with an sbspace:

  1. Create an sbspace with the onspaces utility.
  2. Optionally, set the default sbspace for the database server.
  3. Create a virtual index with the CREATE INDEX statement.
Parent topic: Create and specify storage spaces
Copyright© 2019 HCL Technologies Limited