Creating an isolated namespace

An isolated namespace can be defined by using the CREATE TENANT statement. The resulting tenant object represents a set of system catalogs that are unique from any other namespace in your database. All tenant objects currently defined on the database can be viewed by using the SYSCAT.TENANTS catalog view.

About this task

Each namespace separation is assigned a permanent, unique identifier at the time it is created. This identifier is referred to as a tenant ID. The identifier is not reused by any past or future tenant in the same database.

All additional catalog tables that are created for a namespace separation are created in the catalog table space. As a result, each new tenant created consumes more space in this table space.

Procedure

From the command line, create an isolated namespace.

CREATE TENANT <tenant_name>

where tenant_name is the name of the isolated namespace.

For more information, see the CREATE TENANT statement.