| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Updates via Update Statement in the Database Node of WMB 6.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| ChristophPaul |
 Posted: Thu May 28, 2009 12:34 am Post subject: Updates via Update Statement in the Database Node of WMB 6.1 |
 |
|
Newbie
Joined: 27 May 2009
Posts: 1
|
Hi community,
I think I have the following problem with the Database Node in WMB 6.1: If I issue an update Statement, it first locks the whole table
| Code: |
| UCHAR * 0x123 [-3] "SELECT ID FROM USER.TABLE FOR UPDATE OF COL1, COL2, ..., COL5" |
with no where clause - before it does the actual update:
| Code: |
| UCHAR * 0x124 [-3] "UPDATE USER.TABLE SET COL1 = ?, COL2 = ?, ..., COL5 = 'oki' WHERE CURRENT OF SQL_CURSH234" |
So if you have eg. one million rows, this locks down all of them, even if the where clause in the original statement hits just one single row. More flow-threads are leading to even more locks.
So my question: Is anyone else experiencing this? And probably found a solution?
Christoph  |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
