Configuring › How to Implement Multi-Tenancy › Utilities Used for Multi-Tenancy › pdm_tenant_delete—Deleting Tenant Data from a Database

pdm_tenant_delete—Deleting Tenant Data from a Database

The pdm_tenant_delete utility removes all data for a specified tenant from the database.

Important! The referential constraints on the ca_ tables must be dropped before running pdm_tenant_delete and restored afterwards.

This utility has the following syntax:

pdm_tenant_delete -h|-t tenant_name [-C|-R] [-Q]

-h

Displays the usage information for pdm_tenant_delete.

-t tenant_name

Specifies the name of the tenant of the data to be deleted.

Note: The tenant must be marked inactive before you can use this utility to delete the data.

-C

Specifies that all contacts for a tenant will be marked inactive. Since contacts can be shared between products, default logic should not mass delete or mass inactivate contacts unless explicitly requested.

Note: This option is ignored if the -R option is specified.

-R

Specifies that all rows in all tenanted tables marked CA_COMMON in ddict.sch will be deleted, including the tenant object itself.

Important! These tables are shared between multiple products, so use this option with caution.

-Q

Specifies quick query processing to execute database queries as fast as possible. If this argument is not specified, the utility uses background query processing so that queries run only when the system is otherwise idle. This argument improves running time at the expense of a greater impact on an active system.

Important! On UNIX, the LIBPATH must be set before running several CA SDM utilities. Use pdm_task to set the LIBPATH before running a utility. For example, input "pdm_task pdm_clean_attachments ...".