Archives of the TeradataForum

Message Posted: Mon, 19 Jun 2006 @ 20:34:15 GMT

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

<-- Anonymously Posted: Monday, June 19, 2006 02:23 -->

It is very use full information for data migration Rommel. DB2 runs in MVS, DB2 data needs to be migrated to Teradata(It runs in NCR MP RAS) and data volume is high(Average 20 GB per table).

Currently we have solution for data migration as unload DB2 tables and send it to temporary machine to hold data(we have restriction to store on the same MVS machine where DB2 lies) then load to tetadata using mload phase by phase because.

Alternatively, we are thinking to use OLE DB access module for the same job. This will reduce migration time and no need of unload and load tow jobs.

Can you please share your experience which approach is good and pros and cons of both approach.

Thanks in Advance

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