Storage spaces and fragmentation
An SQL statement fails if it specifies a storage space
that does not agree with the am_sptype purpose value in the sysams system
catalog table. In the user guide, specify whether the access method
supports sbspaces, extspaces, or both. Advise the user how to do the
following:
- Create sbspace or extspace names with the onspaces command
- Specify a default sbspace if the access method supports sbspaces
- Locate the default extspace if the access method creates one
- Specify an IN clause in a CREATE TABLE or ALTER FRAGMENT statement
If the access method supports fragmentation in sbspaces, advise the user to create multiple sbspaces with onspaces before issuing an SQL statement that creates fragments.