Author: mamwl1 Message: Hi,
It is generally a very bad idea to have long running transactions. Certainly something that runs a single transaction for hours is very bad. If you are actually doing transactional work then the work will get undone anyway as a result of the transaction timing out. Which means you have just wasted all your time. Additionally transactions hold numerous locks in databases etc so long running ones result in resource constraints. Do you need to do your batch work in a transaction? If you post your logs it might give me some clues as to why the pause occurred. Regards, Matt. To respond to this post, please click the following link: <http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14674722> ____________________________________ Unsubscribe via the "binocular" icon on the web
