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. Advertisements

  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. Advertisements

  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. Advertisements

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. Andy G

    ADODB.Connection closing issues

    Andy G, Nov 14, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    4,317
    Andy G
    Nov 14, 2005
  2. Andrew Johnson
    Replies:
    2
    Views:
    4,885
    Sudsy
    Oct 20, 2004
  3. Replies:
    0
    Views:
    7,946
  4. mechweb

    ASP connection to DB2/AS400

    mechweb, Jul 7, 2003, in forum: ASP General
    Replies:
    9
    Views:
    475
    Ray at
    Jul 7, 2003
  5. Steve
    Replies:
    0
    Views:
    390
    Steve
    Feb 28, 2006
  6. Dinesh
    Replies:
    0
    Views:
    289
    Dinesh
    Apr 3, 2006
  7. Replies:
    0
    Views:
    308
  8. Nicholas Quaine

    DBI:ibm_db connection for IBM DB2 database

    Nicholas Quaine, Apr 25, 2008, in forum: Ruby
    Replies:
    2
    Views:
    338
    Gerardo Santana Gómez Garrido
    Apr 29, 2008
Loading...