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.
Log in to the Portal Server as user aptare.
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.
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;