Alter a smart-large-object column

You can use the PUT clause of the ALTER TABLE statement to change the storage location and the storage characteristics of a CLOB or BLOB column. You can change the sbspace where the column is stored and also implement round-robin fragmentation, which causes the smart large objects in the CLOB or BLOB column to be distributed among a series of specified sbspaces. For example, the ALTER TABLE statement in the following example changes the original storage location of the advert.picture column from s9_sbspc to the sbspaces s10_sbspc and s11_sbspc. The ALTER TABLE statement also changes the characteristics of the column:

advert         ROW (picture BLOB, caption VARCHAR(255, 65)),
   
;

PUT advert IN (s9_sbspc)
   (EXTENT SIZE 100)

ALTER TABLE catalog 
   PUT advert IN (s10_sbspc, s11_sbspc)
   (extent size 50, NO KEEP ACCESS TIME);