The CREATE_STORAGEMGMT_TABLES procedure creates all storage
management tables under a fixed "DB2TOOLS" schema, in the table space
specified by input.
Syntax
>>-CREATE_STORAGEMGMT_TABLES--(--in_tbspace--)-----------------><
The schema is SYSPROC.
Procedure parameters
- in_tbspace
- An input argument of type VARCHAR(128) that specifies the table
space name. The input argument cannot be null. If a null value is
specified, an SQL0443 error with SQLSTATE 38553, and token DBA7617
is returned.
Authorization
EXECUTE privilege on the
CREATE_STORAGEMGMT_TABLES procedure.
You must also have CREATETAB
privilege on the database and USE privilege on the table space, and
one of:
- IMPLICIT_SCHEMA authority on the database, if the implicit or
explicit schema name DB2TOOLS does not exist.
- CREATEIN privilege on the schema, if the schema name of the table
exists.
- DBADM authority
Usage notes
The following tables are created
in the DB2TOOLS schema:
- STMG_CONTAINER
- STMG_CURR_THRESHOLD
- STMG_DATABASE
- STMG_DBPARTITION
- STMG_DBPGROUP
- STMG_HIST_THRESHOLD
- STMG_INDEX
- STMG_OBJECT
- STMG_OBJECT_TYPE
- STMG_ROOT_OBJECT
- STMG_TABLE
- STMG_TABLESPACE
- STMG_TBPARTITION
- STMG_THRESHOLD_REGISTRY