PROUTIL DEALLOCATE qualifier

Deallocate a multi-tenant table from a database enabled for multi-tenancy.

Syntax

proutil dbname -C deallocate [owner.]table-name

tenant [tenant-name | group group-name ]

Parameters

db-name

Specifies the database with the table to be deallocated.

[owner.]table-name

Specifies the name of the multi-tenant table to be deallocated. owner is required if the table owner is not PUB.

tenant tenant-name

Specifies the tenant whose table partition is to be deallocated. tenant-name cannot be a member of a group.

group group-name

Specifies the group whose table partition is to be deallocated.

Notes

DEALLOCATE works both online and offline.

DEALLOCATE only executes on multi-tenant tables in a multi-tenancy enabled database.

Multiple instances of DEALLOCATE can run online at the same time, provided they are not attempting to deallocate the same table for the same tenant or group.

The super-tenant can deallocate other tenant's or group's table instance.

If DEALLOCATE detects any users (particularly no-lock readers) when the deallocation is executing, the utility waits for them to exit from the transition state printing the following messages:

Waiting for user(s) to finish record operation.
If you'd like to cancel this operation, press CTRL-C.