Archives of the TeradataForum

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

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

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>>