on 12-08-2015 3:53 PM
Hello Experts,
We have been running the archive package at the end of our daily package for the past two years. We recently stopped because it was taking too long. What is this package doing and is it necessary?
Thank you,
Robert
Hi Robert,
archive data package is used to archive audit data in the environment and move into a different table for longer term storage.
it all depends on your requirement on how many years of audit data do you need to store. as years goes on more and more audit data exists.
Talk to the business and determine a time frame and purge all the old audit data, then your package will be fast again.
have a look at note 1846139
quote:
When running the /CPMB/ARCHIVE_DATA package, the "Set purge frequency keep audit records for 'number of' days" needs to have a value since this process chain will use the timeframe to reference which data to archive.
It is necessary to specify the category to use and the timeframe will be pulled from the 'purge frequency' setting.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you provide some details? Unfortunately I can't see your screen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.