Loading from DB2 to Teradata

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Loading from DB2 to Teradata

Rate Topic

Display Mode

Topic Options

Author

Message

satya

Posted 12/28/2005 7:58:00 AM

Junior Member

Group: Forum Members
Last Login: 8/20/2008 3:04:37 AM
Posts: 22, Visits: 24

Hi..
How r u frnz ?
currently am using Mload to Load data from Flat files to Teradata.
I wanna know the Process of loading the data from DB2 to Teradata.
IS thr any Special tools for dat ?
Can plz send me some Sample script?
Thanks & Regards
satya

Cheers,
Satish
Teradata Certified Master
Comfin-EDW

Post #3257

Divvy

Posted 1/3/2006 1:18:01 AM

Forum Guru

Group: Forum Members
Last Login: 3/27/2007 5:35:00 AM
Posts: 58, Visits: 1

Hi

We just converted some of our DB2 to TeraData and we had to use and ETL tool for this process.

You could also try but you have to be careful, downloading from DB2 usning the UNLOAD or DSNTIAUL, then exporting (FTP - BIN) the SYSREC to your machine. Then you need to create the exact structure i.e. DDL on Teradata (remember to convert any DB2 SQL to TeraData, there are not manny),and use MLOAD to load the data into TeraData.

I have done it once but it is a major trail and erro process before you get it right. It is fast easier with an ETL tool.

Divvy

That's All Folks

Divvy

Certified TeraData Master

Post #3281

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:12pm