Oct 31st, 2008, 01:03 PM
-805 in DB2 for z/Os
I'm trying to run a Spring Batch over a DB2 for z/Os database. All runs pretty well at the begining but when the number of records increases an -805 error appers.
The exception looks like this:
DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: CAGDSNP.NULLID.SYSLH203.5359534C564C3031;DISTSERV; 04
I've tried changing the commit interval but there was no difference. Then I talk with de dba and they did a bind on package SYSLH203. Then, job holds a little bit more but crashed again with SYSLH204 package. Actually, I have no idea about DB2 administration, but the dba says that it's something that Spring Batch is doing wrong, but I disagree.
If anyone can brought me some light about this, it would be very very appreciated.
The amount of SQL Queries are about 2.000 if it helps.
Thanks in advance.
Tags for this Thread