Working with database objects in remote table spaces

To use remote table spaces backed by object storage, first create column-organized tables in each of the two table spaces. Afterward, you can operate on these tables normally by loading data into them and querying them.

These tables should perform and behave equivalently to column-organized tables in table spaces backed by network-attached block storage.

To create a column-organize table in the default remote table space, use the following:

CREATE TABLE CT1 (c1 INT NOT NULL, c2 INT NOT NULL) 
       IN OBJSTORESPACE1 
       ORGANIZE BY COLUMN

To create a column organized Declared Global Temporary table use the following:

DECLARE GLOBAL TEMPORARY TABLE GTT1 (c1 INT NOT NULL, c2 INT NOT NULL) 
    IN OBJSTORESPACEUTMP1 
    ORGANIZE BY COLUMN