The DROP_STORAGEMGMT_TABLES procedure attempts to drop
all storage management tables.
Syntax
>>-DROP_STORAGEMGMT_TABLES--(--dropSpec--)---------------------><
The schema is SYSPROC.
Procedure parameters
- dropSpec
- An input argument of type SMALLINT. When dropSpec is set to 0, the process stops when any error is encountered;
when dropSpec is set to 1, the process continues,
ignoring any error it encounters. 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 DROP_STORAGEMGMT_TABLES
procedure.
The user ID that establishes the database connection
must either be the definer of the storage management tables as recorded
in the DEFINER column of SYSCAT.TABLES, or have at least one of the
following privileges:
- DBADM authority
- DROPIN privilege on the schema for these tables
- CONTROL privilege on these tables
Default PUBLIC privilege
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC
when the procedure is automatically created.
DB2 Version 10.1 for Linux, UNIX, and Windows