CREATE_STORAGEMGMT_TABLES procedure - Create storage management tables

The CREATE_STORAGEMGMT_TABLES procedure creates all storage management tables under a fixed "DB2TOOLS" schema, in the table space specified by input.

Syntax

Read syntax diagramSkip visual syntax diagramCREATE_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

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the procedure is automatically created.

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