Creating database objects

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.

Create a column-organized table in default table space

To create a column-organizes 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

Create a column-organized temporary table

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