|
(Added formatting for restart)
|
(→Command Traces)
|
| Line 31: | |||
| <pre>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | <pre>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | ||
| + | == Lockable Resources & Lock Holders == | ||
| + | Lockable resources, whether defined or scripted, as well as any resource acquired & holding a lock, should be present in the locking tables of anthillpro. If the locks need cleared, and cannot be revoked manually (or there are simply too many to revoke) it is possible to clean these up via SQL. | ||
| + | === SQL to Clear All Locks === | ||
| + | <pre>DELETE FROM LOCK_HOLDER_LOCK_RES; | ||
| + | DELETE FROM LOCK_HOLDER;</pre> | ||
