Issues with a DB2 connection

M

Mike

Hi,
I am working against a DB2 database, with the JT400.jar. I am
currently experiencing problems when I try to
access recordsets that are > 200.000 records.

The connection seem to time out. I get no error message the connection
just freezes up.

Do you have any suggestions on what to do here...

BR
Mikal Skaaren
 
I

Ingo Menger

Hi,
I am working against a DB2 database, with the JT400.jar. I am
currently experiencing problems when I try to
access recordsets that are > 200.000 records.

The connection seem to time out. I get no error message the connection
just freezes up.

Do you have any suggestions on what to do here...

I'd first make sure (I mean: absolutely sure) that the JDBC driver
doesn't try to hold the result set in memory.

How is memory usage/GC activity when "the connection freezes"?
 
?

=?ISO-8859-1?Q?Arne_Vajh=F8j?=

Mike said:
I am working against a DB2 database, with the JT400.jar. I am
currently experiencing problems when I try to
access recordsets that are > 200.000 records.

The connection seem to time out. I get no error message the connection
just freezes up.

Do you have any suggestions on what to do here...

May we see a relevant code snippet ?

Arne
 
R

Roedy Green

I am working against a DB2 database, with the JT400.jar. I am
currently experiencing problems when I try to
access recordsets that are > 200.000 records.

I could imagine a hairy query that can't produce any results without
collecting and sorting a huge number of records first. Perhaps the
query requires sequentially scanning the entire database.

I think what you want to do is find out what sort of strategy it is
using to execute the query. Perhaps then you will be able to prod it
along with an index, an aux table etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top