Archives of the TeradataForum
Message Posted: Tue, 25 Jun 2013 @ 22:23:51 GMT
We are currently migrating the data from db2 to teradata. ?In DB2 the load utility is taking 156 mins to load 36 GB compressed file (.Z file), in teradata we are using the named pipe to read the compressed load ready file and it is taking 265 min to load the data, in teradata we use tpt ? update operator (3 producer and 3 consumer instance, Physical node ? 20 , 1200 Amp).,users are comparing the load time between the db2 vs teradata, and we need to improve the load perfomace. Can you please provide some inputs or ways of reducing the load time in teradata.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|