Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Apr 2007 @ 15:36:37 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Accessing or Loading DB2 data from Teradata
 
From:   Geoffrey Rommel

  We have a need to transfer DB2 data into Teradata.  


First of all, is this DB2 on the mainframe (z/OS) or on Unix?

On the mainframe, you have these options at least:

- Export the data to a flat file and load that file to Teradata with the MVS version of FastLoad or MultiLoad. Probably the best option.

- If ODBC is enabled on your DB2 subsystem, use OLE DB and tell it to read from an ODBC source. (Could be slow, though.)

- Write an INMOD that reads the data from the table and feeds it to FastLoad or MultiLoad.

This technique is described here:

www.teradataforum.com/l030315a.htm

- Use a third-party ETL tool such as DataStage or Informatica.


If your DB2 is on Unix, the options are basically the same, but OLE DB may be the best. I haven't used OLE DB for this purpose, and I don't see a DB2/UDB driver in my copy of it, but perhaps there is one. If not, you could use ODBC.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023