Set the am_sptype value
Set the am_sptype value to S if
the access method reads and writes to sbspaces but not to extspaces.
Set the am_sptype value to X if the access
method reads and writes only to extspaces but not to sbspaces.
To set the am_sptype purpose value, use the CREATE SECONDARY ACCESS_METHOD or ALTER ACCESS_METHOD statement, as SQL statements for access methods describes.
If you
do not set the am_sptype storage option, the default value
A means
that a user can create a virtual index in either extspaces or sbspaces.
The access method must be able to read and write to both types of
storage spaces. Important: In the access-method user guide,
notify users whether the access method supports sbspaces, extspaces,
or both, and describe default behavior. The database server issues
an SQL error if the user or application attempts to use a storage
space that the access method does not support.