MQSeries.net :: View topic - Message broker commits Db2 on Db2 lock table

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message broker commits Db2 on Db2 lock table

Message broker commits Db2 on Db2 lock table

« View previous topic :: View next topic »

Author

Message

swarna.prava.mohanty

Posted: Thu Feb 24, 2011 2:00 am Post subject: Message broker commits Db2 on Db2 lock table

Novice

Joined: 29 Aug 2010
Posts: 15

Hi All,

I have a message which has 1500 records to be inserted into a Db2 table. But after 1000 records Db2 table get locked. In compute node the transaction is "Automatic" so the transaction should get rolled back as Db2 lock occurs but those 1000 records are getting committed or successfully inserted in the table. Can u please tell hows its possible.

smdavies99

Posted: Thu Feb 24, 2011 2:34 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

This seems very similar to the last few posts on this thread

http://www.mqseries.net/phpBB2/viewtopic.php?t=56372
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message broker commits Db2 on Db2 lock table

Jump to:

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

Protected by Anti-Spam ACP