By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

SQL10003C

P: n/a
One of the java developer is getting error

SQL10003C
There are not enough system resources to process the request. The
request cannot be processed.

They are running massive SQL which runs fine and send result to JDBC
resultset. then they run bunch of small sql on resultset. then they
receive above error

I do not see anything in diaglog. Is there a possibility that this
error is generated by db2 client?

Mar 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I'd go back to the developer and verify what they told you. A JDBC
result set is the output of an SQL query. I've never heard of "running a
bunch of small sql on the (JDBC) result set."

Phil Sherman

db2admin wrote:
One of the java developer is getting error

SQL10003C
There are not enough system resources to process the request. The
request cannot be processed.

They are running massive SQL which runs fine and send result to JDBC
resultset. then they run bunch of small sql on resultset. then they
receive above error

I do not see anything in diaglog. Is there a possibility that this
error is generated by db2 client?
Mar 6 '07 #2

P: n/a
I am sorry for confusing everyone
queries are actually run against database only but they are
constructed ( where clause ) using data from resultset of large query
program ( java code ) loop through result set of large query ( ~ 1
million rows ) and construct small SQL
my question is if db2 client can be overwhelmed with memory
requirement of resultset for large query and cause db2 errror i
mentioned earlier
On Mar 6, 12:44 pm, Phil Sherman <psher...@ameritech.netwrote:
I'd go back to the developer and verify what they told you. A JDBC
result set is the output of an SQL query. I've never heard of "running a
bunch of small sql on the (JDBC) result set."

Phil Sherman

db2admin wrote:
One of the java developer is getting error
SQL10003C
There are not enough system resources to process the request. The
request cannot be processed.
They are running massive SQL which runs fine and send result to JDBC
resultset. then they run bunch of small sql on resultset. then they
receive above error
I do not see anything in diaglog. Is there a possibility that this
error is generated by db2 client?

Mar 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.