Configure multi-tenancy data purging retention periods

In multi-tenancy environments, where IT Analytics domains partition client data, data retention periods can be configured for each domain. The data retention period for a domain applies to that domain and all of its sub-domains. For systems collected by traditional Data Collectors, use the procedure described in the following section:

See System configuration: functions.

To enable purging for a user-defined object for a specific domain, take the following steps.

Type the following command:

sqlplus portal/<portal_password>@//localhost:1521/scdb

At the command line, execute the following SQL statement, substituting relevant values for the variables shown < > in the syntax.

INSERT INTO apt_purge_rules (table_name, product_type, table_description, date_column_name, retention_days, default_retention_days, domain_id, creation_date, last_updated)
SELECT table_name, product_type, table_description, date_column_name, <NewRetentionDays>, default_retention_days, <domain_id_value>, SYSDATE, SYSDATE
  FROM apt_purge_rules
 WHERE domain_id IS NULL
   AND table_name = <tableName>;
Commit;

See Find the domain ID and database table names.

See Retention Period Update for Multi-Tenancy Environments Example.

Retention Period Update for Multi-Tenancy Environments Example

The following example illustrates an update for a Pure Storage performance database table.

INSERT INTO apt_purge_rules (table_name, product_type, table_description, date_column_name, retention_days, default_retention_days, domain_id, creation_date, last_updated)
SELECT table_name, product_type, table_description, date_column_name, 50, default_retention_days, 100007, SYSDATE, SYSDATE
  FROM apt_purge_rules
 WHERE domain_id IS NULL
   AND table_name = 'SDK_PURE_STORAGEARRAY_PERF';
Commit;

Configure multi-tenancy data purging retention periods

Feedback

Feedback