Use the TENANT option to specify the tenant to be considered for a
given task unloading data from a local database.
When this clause is specified, the task executed can only
process tables being part of the tenant specified. If the task is related to the processing of a
whole database, all tables within the chosen tenant are processed. If the task is related to the
processing of a whole tablespace, all tables located in this tablespace within the chosen tenant
are processed. If there is one or more SELECT statements explicitly specified, each one must
refer to a table existing in the chosen tenant. This option can be used only if the Db2® environment is a V12.1 one at least.
- TENANT
-
- Syntax
- TENANT tenant_name
- Variable
- tenant_name
- The value which can be specified to it must be a Db2 identifier corresponding to an existing tenant name.
- Default
- SYSTEM.
- This default value corresponds to the tenant called SYSTEM being the default one for Db2 as well.