Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    2

    Unanswered: Extract performance

    I'm looking to extract about 40 Million rows out of a DB2 database. My question has to do with which method will yield the best performance. I can use JDBC to run a select statement via Java. Or I can use the extract command to extract the data in XML. Which choice will be the fastest? Are there any other options available?

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What do you want to do with the data once it is "extracted"?

    Oh, and it may be a good idea to tell us which DB2 version you are using on which platform.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Sep 2008
    Posts
    2
    The data is being passed to a 3rd party program. This program has facilities to bring in data via JDBC, but I've found that the extracts take about 6 hours. The other option is to extract via XML, but I'm not sure how fast that will be.

    I'm using db2 8.1 on aix

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •