You can specify multiple sbspaces in the PUT clause of the CREATE TABLE statement to achieve round-robin fragmentation of smart large objects on a column. If you specify multiple sbspaces for a CLOB or BLOB column, the database server distributes the smart large objects for the column to the specified sbspaces in round-robin fashion. Given the following CREATE TABLE statement, the database server can distribute large objects from the cat_photo column to sbcat1, sbcat2, and sbcat3 in round-robin fashion.
CREATE TABLE catalog ( catalog_num SERIAL, stock_num SMALLINT, manu_code CHAR(3), cat_descr LVARCHAR, cat_photo BLOB) PUT cat_photo in (sbcat1, sbcat2, sbcat3;