AEDB is nearly full and there is a need to clear data quickly to make space. DBMaint is too slow.

Document ID : KB000091701
Last Modified Date : 11/06/2018
Show Technical Document Details
Issue:
The AEDB is nearly full and there is a need to clear data quickly to make space.
DBMaint is running too slowly and may not be able to finish running before the DB fills up.
Environment:
WORKLOAD AUTOMATION AE, Release: 11.3.6
Resolution:
Events can be deleted manually from the ujo_proc_event table to free space quickly using the following SQL:

DELETE FROM ujo_proc_event WHERE eoid in (SELECT distinct eoid FROM ujo_proc_event e LEFT JOIN ujo_job_status s ON e.joid=s.joid AND e.run_num=s.run_num and e.ntry=s.ntry LEFT JOIN ujo_job j ON e.joid=j.joid AND e.job_ver = j.job_ver AND j.over_num = e.over_num WHERE event_time_gmt < %d AND (s.status not in (1,3,10,13,17) OR s.joid IS NULL OR j.is_active = 0))

NOTE:
Make sure the Primary Scheduler is stopped before running this SQL. If running Dual DBs, you must execute this on both databases.
Use with caution. Please note that the archiving will not happen if you use this query. If you have any doubts, please contact CA Support.