• No replies
1 Post

Pinned topic Commit Count

‏2013-07-30T16:56:42Z | commit count

Hi, we have a JAVA process which updates a DB2 table on MVS system. (DB2 Version 9.2)  We process hundreds of thousand of update statements.  If we batch 1000 statements and commit, there is no issue. Job completes successfully, ~ 1/2 million statements were executed. If we set the batch size to 5000 and commit,  job hangs after 25K are committed. I'm not seeing an issue with code. Is there DB2 parameter which needs to be set?          

Steve Drogo