Creating and Dropping Remote Table Spaces

Remote table spaces can be created using the CREATE TABLESPACE statement and linked to remote storage groups. They can also be dropped by using the DROP TABLESPACE statement.

Creating a remote table space

A remote table space is a DMS table space that is created by using the CREATE TABLESPACE statement and associated with a remote storage group by using the USING STOGROUP <remote-storage-group> clause.

A remote table space must use automatic storage and will only be DMS table spaces.
It is associated with a single remote container, as defined in the remote storage group.
It only supports AUTORESIZE YES and can use MAXSIZE to limit its size.

Example statements:


CREATE TABLESPACE <your_tablespace_name> USING STOGROUP IBMDEFAULTREMSG1 AUTORESIZE YES MAXSIZE size


CREATE TABLESPACE <your_tablespace_name> USING STOGROUP IBMDEFAULTREMSG1

Note:

Replace <your_tablespace_name> with table space names appropriate for your environment. The storage group name 'IBMDEFAULTREMSG1' is required and must not be changed.

Dropping a remote table space

Dropping a remote table space uses the DROP TABLESPACE statement and behaves like dropping any other table space. This action permanently deletes all associated files and objects, including those files stored locally and in object storage.

Example drop statement:


DROP TABLESPACE <your_tablespace_name>