Four update SQLs in one DS job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
Four update SQLs in one DS job
Hi,
I need to execute 4 update SQLs on the same table in SQL Server database in a DS job. I cannot put the 4 Update SQLS together in one ODBC Connector stage. I want the SQLS to execute one after the other because if the SQLs are fired simulatneously, then a deadlock of table occurs. If I use 4 different ODBC connector stages one for each SQL, then too the SQLS would get fired simulatneously and the table would get deadlocked. Can you suggest me a way to do this?
I need to execute 4 update SQLs on the same table in SQL Server database in a DS job. I cannot put the 4 Update SQLS together in one ODBC Connector stage. I want the SQLS to execute one after the other because if the SQLs are fired simulatneously, then a deadlock of table occurs. If I use 4 different ODBC connector stages one for each SQL, then too the SQLS would get fired simulatneously and the table would get deadlocked. Can you suggest me a way to do this?
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Commit immedately (transaction size = 1) and keep your transaction isolation level to the minimum possible setting. Otherwise write all the updates to a staging area, and run another job to effect all the updates in a single run.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI