Archives of the TeradataForum
Message Posted: Wed, 09 Jul 2003 @ 14:46:54 GMT
| Subj: | | Re: Fastload performance |
| |
| From: | | Geoffrey Rommel |
| | The source table of ibm-db2 has 2G data.It took 2 hours to load data from ibm-db2 to teradata. Is it normal? If not,how can i
imporve the performance when using fastload utility? | |
Are you unloading the data from DB2 to a flat file and then running the FastLoad? If so, you can speed things up by writing an
INMOD that will read directly from DB2. There is a paper in the forum library that explains how:
www.teradataforum.com/l030315a.htm
If you're already doing this, you may be able to make it faster by increasing the MVS scheduling priority of your job. I don't know
the details of how to do that.
| 
