DB2 10.5 on Windows Server
If I have something like this...
CALL WEB SERVICE; (can take up to 8 seconds)
DELETE FROM TABLE3;
How would DB2 handle the tables during the life of the transaction? Would it only lock a table when the change is made or would if lock the tables at the start of the transaction? I am not familiar with DB2 transactions and while the IBM info pages describe how they work, none of it answers this question.
I am making the assumption that they are similar to transactions in SQL Server although I do see some references to SAVEPOINTS which I am not sure I understand. I think that might not apply to DB2 on windows.
Thank you so much for any help in advance.