aspose file tools*
The moose likes JDBC and the fly likes JDBC vs DB2 Export - Performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC vs DB2 Export - Performance" Watch "JDBC vs DB2 Export - Performance" New topic
Author

JDBC vs DB2 Export - Performance

Jaime Garcia
Ranch Hand

Joined: Jan 07, 2003
Posts: 38
I am working with DB2 and I have to export (2 times per day) a lot of information from a table (DB2 database). I Know that exist a Utility from DB2 (export utility) but, because I need to update the rows that I export, I would prefer to use JDBC (I think that I could have more control with JDBC) but I am worried about performance.
Dose any body Know if the export utility is faster (and better) than using JDBC ?
I Know that importing information is better to use the load Utility, but export information just read rows, so I think (hope) is mostly the same.
Thanks
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
the answer is, it depends.
if you are doing a strait extract, export will be much faster.
if you need to extract data population A and update data population B
at the same time. then you have to code and application.
ie.
pgm begin
connect
select ...
update ...
terminate
pgm end
Try to use JDBC 2.0 with addBatch() / executeBatch() if possible.
Hope this helps


Multi Platform Database Developer & DBA on E.S.T.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC vs DB2 Export - Performance
 
Similar Threads
Replicate tables
How to handle parallel or concurrent updates
Head First SQL - Standard SQL
Exporting data from a table using JDBC
DB2 Error