Restricted activity on resource limit tables

While the resource limit facility is active, you cannot execute certain SQL statements on the resource limit tables, or the table space and database that contain the resource limit table

The statements that are restricted while the resource limit facility is active are:

  • DROP DATABASE
  • DROP INDEX
  • DROP TABLE
  • DROP TABLESPACE
  • RENAME TABLE

You cannot stop a database or table space that contains an active resource limit table; nor can you start the database or table space with ACCESS(UT).