Can I perform DB backups while CAWA DE is running?

Document ID : KB000011024
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Should the CAWA DE Server be shut down during CAWA DB maintenance?

Answer:

It is highly recommended to not perform any database maintenance operations while the CA Workload Automation (CA WA) server is up. If a backup or any maintenance is performed, a deadlock situation can occur if CA WA and any other processes try to access the same tables or DB objects at the same time. The external (non CA WA) processes can put a lock on a table, then the CA WA server will not be able to access those objects and will possibly shut down with a fatal error.

To do a complete backup, shut down CA WA service and then perform the database backup as per requirement.