AEDB is nearly full and there is a need to clear data quickly to make space. DBMaint is too slow.
Article ID: 91701
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)
CA Workload Automation AE - Scheduler (AutoSys)
Workload Automation Agent
Issue/Introduction
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.
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.
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.
Feedback
Yes
No
Powered by
