Due to other prior issues DBMaint did not run for years so the autosys database is very large.
Now when we try to run DBMaint or archive_events they run very slow.
Release : 11.3.6
Due to other prior issues DBMaint did not run for years so the autosys database became very large.
DBMaint and archive_events are working when the retention rate is set to trim older data in small increments.
The client needed to continue lowering the retention rate little by little or truncate the tables and start fresh.
NOTE - they would truncate only a few select tables: