I need to connect a DB2 server outside my firm to extract the data and import to my Oracle DB. This action has to be taken periodically. Efficient performance is necessary. How could I do that? I tried to use Access 2007 with ODBC to connect the DB2 and import to my Oracle DB (using ODBC). It worked but the performance is unacceptable. It took 40 minutes to extract the data from a view with 5 columns with 100,000 data amount. Any better suggestions? Please help. Thanks a lot!!.
try to use the export command in command line..
see with explain if the access-path to data is as expected..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be