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?