Stored procedures for the storage management tool - IBM DB2 9.7 for Linux, UNIX, and Windows

This topic shows the stored procedure functions that are created for the storage management tool.

The stored procedures are automatically created when the database is created. Also, their respective packages are bound on demand.

Table 1. Stored procedures for the storage management tool
Fully qualified name	Parameters	Functionality
SYSPROC.CREATE_STORAGEMGMT_TABLES	in_tbspace VARCHAR(128) input - table space name	Creates all storage management tables under a fixed "DB2TOOLS" schema, in the table space specified by input.
SYSPROC.DROP_STORAGEMGMT_TABLES	dropSpec SMALLINT input - 0 / 1	Attempt to drop all storage management tables. When dropSpec=0, the process will stop when any error is encountered; when dropSpec=1, the process will continue ignoring any error it has encountered.
SYSPROC.CAPTURE_STORAGEMGMT_INFO	in_rootType SMALLINT input all valid values are given in STMG_OBJECT_TYPE table in_rootSchema VARCHAR(128) input - schema name of the storage snapshot root object in_rootName VARCHAR(128) input- name of the root object	Attempt to collect for system catalog and snapshot the storage-related information for the given root object, as well as its the storage objects defined within its scope. All the storage objects are specified in STMG_OBJECT_TYPE table.