How to overcome table locking after applying a trigger to a table
Posted on 2004-08-02
need some advice on how to overcome a problem when applying a trigger.
I had a SP which download from DB2 to table A record by record (using a looping). I create a trigger (insert/delete/update) to table A so that any transaction on table A will effect table B as I need a realtime mirror between table A and B.
But I face a problem where table A was locked during the download (didn't happen before I apply the trigger) which cause another application could not access this table A(retrieve/insert data).
How to overcome this?