We need to disable Microsoft lock Escalation on our Automic database.
So we need a detailed list of all tables in Automic Version 10.8 database, where activities are written so that we can give to our db admin to deactivate.
The Automation Engine reads and writes in numerous tables while processing. It's not just about the "activities". Here are some of the most-used :
- all MQ tables : MQCP001, MQCP002, MQWP, MQPWP, MQDWP, etc.
- EH : activities
- AH : statistics
- RH / RT : reports
- OH : objects
However this is only a short list and many other tables are also involved as they are linked with one another. For instance OH is linked to AH, EH, OVPP, OHG, etc.
You may find a complete DB schema here : https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE//DB%20Schema//db/_structure/HTML/index.htm#ucaaqm.htm