Issues with a DB2 connection

Discussion in 'Java' started by Mike, Nov 5, 2007.

  1. Mike

    Mike Guest

    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
    Mike, Nov 5, 2007
    #1
    1. Advertising

  2. Mike

    Ingo Menger Guest

    On 5 Nov., 13:34, Mike <> wrote:
    > 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"?
    Ingo Menger, Nov 5, 2007
    #2
    1. Advertising

  3. Mike wrote:
    > 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
    =?ISO-8859-1?Q?Arne_Vajh=F8j?=, Nov 6, 2007
    #3
  4. Mike

    Roedy Green Guest

    On Mon, 05 Nov 2007 12:34:02 -0000, Mike <> wrote,
    quoted or indirectly quoted someone who 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.


    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.
    --
    Roedy Green Canadian Mind Products
    The Java Glossary
    http://mindprod.com
    Roedy Green, Nov 6, 2007
    #4
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Andrew Johnson
    Replies:
    2
    Views:
    4,690
    Sudsy
    Oct 20, 2004
  2. Replies:
    0
    Views:
    7,584
  3. mechweb

    ASP connection to DB2/AS400

    mechweb, Jul 7, 2003, in forum: ASP General
    Replies:
    9
    Views:
    271
    Ray at
    Jul 7, 2003
  4. Dinesh
    Replies:
    0
    Views:
    153
    Dinesh
    Apr 3, 2006
  5. Replies:
    0
    Views:
    173
Loading...

Share This Page