Program Gets DB2 SQL Error After 4600 Commits

[Spab23]

I have a batch program that connects to an IBM DB2 database using IBM DB2 JDBC Universal Driver Architecture version 3.53.81.

It stores records one at a time and does a commit every 200 records. After it commits 4600 records (the total the program is supposed to store is around 5300-5500), it crashes.

Is there a limit to the number of commits? The weird thing is when I run the same program in our Dev/Test environments, it gets past 4600 without a problem.

Here's the error message:

DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB2P.NULLID.SYSLH20C.5359534C564C3031;DISTSERV;04, DRIVER=3.53.81

Can anyone help?

 

[papadba]

If you have not read here, suggest you do so:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.398

This may not be info that will solve your problem, but is the complete info on how a -805 happens.

As far as i know db2 has no limits on the number of commits.

Just as a guess, something has been "walked on" causing the -805.

 

[MarcLodge]

Hi,
The important bit in your error message is the '04' after distserv. Have a look at the excellent link provided by papdba and you will see that it is saying that the package does not exist at the remote site. Clearly this is not the case as you've been happily running the package in the program iteration.

I would look into connection parameters of the JBDC driver. Compare production to test and see if there's a parm that has been tweaked for time, maybe.

I would also have a good look at any db2 logs to see if you can get any more information.

Marc

 

[sathyarams]

or, it could be this.

https://www-304.ibm.com/support/docview.wss?uid=swg21115245

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp