See Unable to unlock jobs in v8 for details.
I am starting a new posting to deal directly with the topic of using a trigger (or some other method) of removing locks from the XMETALOCKINFO table.
The trigger basically does a delete whenever a lock record is inserted and there was reasonable concern over what is actually getting deleted.
Here is the trigger in question (from lstsaur, Thanks!):
Code: Select all
CREATE OR REPLACE TRIGGER CleanupAbandonedLocksTrg
AFTER INSERT
ON XMETA.XMETALOCKINFO
BEGIN
DELETE FROM XMETA.XMETALOCKINFO;
END CleanupAbandonedLocksTrg;
Thoughts anyone?
Brad.