Test the access method for fragmentation support

To test the access method for fragmentation support, specify a different storage space for each fragment.

The following example shows the creation of a table with two fragments. Each fragment corresponds to a separate extspace. The database server alternates between the fragments to store new data.
CREATE TABLE table_name(...)
   FRAGMENT BY ROUNDROBIN IN "location_specifier1",
"location_specifier2"
   USING access_method_name
To fragment a table in smart-large-object storage, create a separate sbspace for each fragment before you create the table. Use the onspaces command, as the following example shows: 
onspaces -c -S fragspace1 -g 2 -p location_specifier1 -o 0 -s 20000
onspaces -c -S fragspace2 -g 2 -p location_specifier2 -o 0 -s 20000

CREATE TABLE catalog (status pages)
   USING catalog_am
   FRAGMENT BY EXPRESSION
      pages > 15 IN fragspace2,
      REMAINDER IN fragspace1