Plan your case archiving process so that it is optimally efficient and meets the needs of your organization's database size.
After you implement an archive process, you can monitor its performance and determine if it needs further changes by reviewing the following details and maintenance suggestions:
- Run a report on the archived cases resulting from your archive process. This reportt is the best way to verify that the process meets your organization's archiving needs.
- To improve searches of archived cases data, optimize the properties on which you can configure a search index. After you have archived case data, configure your archive search indexing based on these specific, optimized properties. For details about property optimization, see Optimizing database properties; for details about marking a case type to be available in a search index, see Including indexed data during case search.
- If your case archival policy includes case types with a parent/child hierarchy, both parent and child cases must be resolved before the policy will archive both the parent and child cases. For more information, seeCases in a hierarchy.
- If you imported a Rule-Admin-Product (RAP) rule with the Data-Retention-Policy class instances, review the case archiving settings for your cases, since this import overrides the case archiving polices.
- To check the performance of your case archiving process (see steps 4c and 4d) add the following custom indexes on the case type worktable
and on the pr_metadata table :
- For the index on the work table for the case type,
(pxobjclass, pyresolvedtimestamp) include (pystatuswork, pzinskey) where pxcoverinskey is null
- For the index on the pr_metadata, enter
(pyisparent, pyarchivestatus) include (pzinskey) (pyobjclass, pyarchivestatus) include (pyInsKey, pzInsKey) (pyobjclass , pyarchivestatus ) include (pyfilelocation , pzinskey, pyinskey)
When running case archive jobs, use the following settings:
dataarchival/LimitPerPolicyto change the rate at which you archive eligible cases.
dataarchival/purgeQueryLimitto change the rate at which you delete records after they are archived to an external repository.
For more information, see Settings that control case archiving processes.
- For the index on the work table for the case type, enter
- Identify the number of cases in your initial backlog and the rate at which cases become eligible for archiving.
- Create a targeted archiving policy for your case archiving needs.For example, your system contains a backlog of 10,000 cases and adds 500 cases a day. For more information about creating an archiving policy, see Creating an archiving policy.
- Schedule a case archiving process that finishes during a time period of
low-system load.For example, your system might experience low system load every day for five hours or every weekend for 12 hours. For more information about scheduling an archiving policy, see Scheduling a case archiving policy.
- Determine the upper range for case archive processing by adjusting the
- Set a low rate in the
dataarchival/purgeQueryLimitdynamic system settings, respectively.
- Run a process with the following jobs by using the low value for the
number of cases:
For more information, see The case archiving process.
- Monitor the progress of your case archiving process. For more information, see Monitoring the progress of your case archiving process.
- Evaluate the performance impact and time that the low rate in your case archiving process has on your system.
- Increase the case archiving settings, and then run the process again
with increased values.A faster rate of archiving impacts system resources more, and takes longer to complete.
- Continue to increase the rate to determine that maximum value with which you can complete the process within a low system load duration and with an acceptable system impact.
- Optional: If you need to preserve archived case data, place an exclusion on archived cases to prevent permanent deletion of the case data.
- Set a low rate in the
- Clear your backlog by using the maximum rate you determined in the previous
step. The maximum rate of case archiving determines the time frame for clearing your backlog.
- Adjust the case archive process after clearing your backlog:
You can also quickly test an archiving policy using a test mode on non-production systems.
- If your current case archiving rate meets or exceeds the rate at which cases become eligible for archiving, keep that archiving rate.
- If your current case archiving rate is slower than the rate at which cases become eligible for archiving, plan to run your case archiving jobs more frequently to archive faster.
- To enable a testing mode to configure an archiving policy
in minutes instead of days, select the Enable testing
mode check box. .
- Select the Enable Archiving check box to set a testing-mode archive.
- In the Archive cases that are resolved earlier than (in days) field, enter the number of minutes that a case requires in a Resolved-* status before it is eligible for archiving.
Use the testing mode when you want to create and resolve sample cases, and then run an immediate case archive process to test the functionality.
Plan to run your case archive jobs at an initially fast rate to clear your backlog of resolved cases and free up database space.