| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 update system Lock |
« View previous topic :: View next topic » |
| Author |
Message
|
| Rockon |
 Posted: Fri Feb 18, 2005 11:07 am Post subject: DB2 update system Lock |
 |
|
Apprentice
Joined: 24 May 2004
Posts: 43
|
Hello All,
Would anybody be able to put some light on an issue w.r.t a database update that occurs on a DB2 table.Apparently when I try to do a database update using ESQL, the system locks as in the table freezes and I cant do anything.
I know itis during updation because that is the only data manipulation that occurs in the ESQL.I tried a test insert and it works fine.
Is this anything todo with setting up buffer size for the table or anything in that order from a DB2 point of view or itis more of Message broker settings.
If itis DB2 may be I can ask my admin to look ito that aspect.
Please do share any thoughts on this.
Environment:WBIMB 5.3, DB2 7.2, WMQ 5.4
Thankyou,
Cheers, |
|
| Back to top |
|
 |
| Rockon |
| Posted: Fri Feb 18, 2005 12:44 pm Post subject: |
|
|
Apprentice
Joined: 24 May 2004
Posts: 43
|
Just throwing in ideas..was wondering if there is
Option 1:An esql stmt that would override the transaction level to low...from what I understand there is only 2 levels Commit and Automatic that can be set at the node properties..is there a level below that...
Option 2:An esql to put a break like "wait 10 sec" before the next transaction occurs..
please do give me some directions to go about this situation...
thankyou,
cheers |
|
| Back to top |
|
|
| martinrydman |
| Posted: Sun Feb 20, 2005 5:39 am Post subject: |
|
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
It would be helpful to know the particulars. Updating as such is usually pretty straight-forward. Post somecode and error messages (if any).
/Martin |
|
| 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
|
|
|
|
