Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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:


- 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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023