Running CEM V6.0 using DB2 as data repository.
A job has been implemented to delete data as described
in the CEM manual in section "Maintain the Repositories (IBM DB2)"
Subsection "Delete Data from the Change Monitor Repository (IBM DB2)".
The job performs very badly.
After running more than 11 hours and using more than 5 hours of CPU time the
job has to be cancelled.
The DBA gives the reason for the long running job as the lack of indexes on the tables.
The delete process seems to scan three of the tables.
What is the best process to define indexes on these tables to improve the runtime of this job?
Release : 6.0
Component : CA COMPLIANCE EVENT MANAGER