This content has been marked as final. Show 9 replies
I can see in
Implementation Guide – Volume 2 – Integration Information
Subject: "Database Considerations"
"This must be coordinated to run after the daily purge batch script that removes already processed or deleted messages from the table."
Clearly indicate that there is purge batch script, for purging data from this table. But problem is, not able to find out the exact pruge script which is used to purge this table
SIM has a purge that runs from the following path:
You can also run it manually through in the package "PURGE_DATA" in the function "DELETE_INTEGRATION_STAGING". This takes all the records that meet the following cursor:
where (processed = 'Y' or deleted = 'Y')
and update_time <= I_date-L_config_value;
where "L_config_value" is configured in the 'rk_config "under the config_value" DAYS_TO_HOLD_COMPLETED_STAGING_RECORDS" and "I_DATE" is the current date.
I hope has been helpful.
Thanks for replying.
I checked in rk_config table that DAYS_TO_HOLD_COMPLETED_STAGING_RECORDS is holding the value as 3. According to the below query it fetches 1 million data as of today in PROD. So 1 million records should be purged by “DELETE_INTEGRATION_STAGING” function.
Could you please advice why batch is not purging data,
select id from integration_staging where (processed = 'Y' or deleted = 'Y') and update_time <= sysdate-3;
When executing "DELETE_INTEGRATION_STAGING" You get an error? Deleting records is tiered according to the value of the variable "I_limit_size", which by default is set to 1000. This means that for every thousand records, deletes and does commit.
Could you provide output of function execution?
Another way to test it, would run in a test or development environment, incorporating trace function to know how many records have been erased.