Purge Data manually from CCC Database

Document created by sinma15 Employee on Mar 21, 2017
Version 1Show Document
  • View in full screen mode

Below query can be used to purge the data manually from CCC database:

begin
Datamart_Lib.ROUTINE_PURGE;
end;

Note : It will purge the data on the bases of the global parameters setting.

Once execution is completed, you can use below query to track the number of rows deleted.

SELECT * FROM purge_log_config ORDER BY insert_date DESC;

Below are the table from which data is being deleted using above package.

1. Prestaging Tables: (Pugred based on "NUMBER_DAYS_PRESTAGE_DATA_RETAINED"  parameter)
PRE_STAGING_ENTITY_CONFIG,PRE_STAGING_ENTITY_METRICS

2. Staging Tables: (Purged based on "TRUNCATE_STAGING_TABLES" parameter)
APPLICATION_METRICS_STAGING,CPU_METRICS_STAGING,GENERIC_DEVICE_METRICS_STAGING,PROCESS_METRICS_STAGING,SERVER_METRICS_STAGING,SERVER_STAGING,
SUBSYSTEM_METRICS_STAGING,WORKLOAD_LOG_STAGING,WORK_TRANS_METRICS_STAGING,SERVER_VIRTUAL_STAGING,DIVERSE_DATA_STAGING,DIVERSE_METRIC_STAGING,
SAP_CONFIG_STAGING,SAP_DAILY_MEMORY_STAGING,SAP_DAILY_STAGING,SAP_DAILY_SUMMARY_STAGING,SAP_HOURLY_TASK_STAGING,SAP_HOURLY_TIME_STAGING,
SAP_RFC_METRICS_STAGING,CLUSTER_METRICS_STAGING,RESOURCE_POOL_METRICS_STAGING,RESOURCE_POOL_STAGING,CLUSTER_STAGING,GROUP_CONFIG_STAGING,ENTITY_METRICS_STAGING

3. Migration Tables:(Purged based on " NUMBER_DAYS_DATA_RETAINED" parameter )
APPLICATION_FACT,CLUSTER_FACT,CPU_FACT,DISK_FACT,DIVERSE_DATA_FACT,DIVERSE_METRIC_FACT,ENTITY_FACT,GENERIC_DEVICE_FACT,NETWORK_FACT,PROCESS_FACT,RESOURCE_POOL_FACT,SAP_DAILY_FACT,SAP_DAILY_MEMORY_FACT,SAP_DAILY_SUMMARY_FACT,SAP_HOURLY_TASKTYPE_FACT,SAP_HOURLY_TIME_FACT,SAP_RFC_FACT,SERVER_FACT,SERVER_TPP_FACT,SUBSYSTEM_FACT,WORKLOAD_LOG_FACT,WORKLOAD_TRANSACTION_FACT

4. Rollup Tables:(Purged based on "NUMBER_DAYS_HOURLY_DATA_RETAINED" parameter ) - ENTITY_HOUR_FACT
                           (Purged based on "NUMBER_DAYS_DAILY_DATA_RETAINED" parameter ) - ENTITY_DAY_FACT

5. Log Tables: ( Purged based on "NUMBER_DAYS_LOGS_RETAINED" parameter )
JOB_ACTIVITY_ERROR,JOB_ACTIVITY_MIGRATE,JOB_ACTIVITY_RESULTS,LOGGING_INFO_CONFIG,REFRESH_LOG_CONFIG,TRANSACTIONS_CONFIG,PURGE_LOG_CONFIG,PROCESS_LOG_CONFIG

 

 

Written By :

   Pradeep Rai 

Attachments

    Outcomes