Teradata TPUMP utility Performance Improvement

Database
Ari
N/A

Teradata TPUMP utility Performance Improvement

Hi,

We are using a TPUMP teradata utility to load around 0.4 million records in the teradata database. The TPUMP is taking more than one hour to load all the records into a database. We want to reduce the time it takes to load the records. Is there any way to improve the performance of TPUMP load utility? We have tried with various combinations of SESSION and PACK parameters but it didn’t work. Please let me know if there is any other way to improve the performance of TPUMP load.

2 REPLIES

Re: Teradata TPUMP utility Performance Improvement

Have you tried multiload? For bulk data Tpump might not be a good choice. TPump is for small feeds but more number of times.

Re: Teradata TPUMP utility Performance Improvement

Consider Multiload as an alternative to TPUMP if the target tables don't have unique secondary indexes or referential constraints (which are not supported by Multiload).

If Multiload is not suitable for the above reasons, you can use Fastload to load the transactions into a temporary table, and then use either INSERT...SELECT, UPDATE, or MERGE INTO statements to apply the transactions to your target table. The latest Teradata release (V2R6.2) has some enhancements that have been specifically designed to improve the performance of this kind of solution. More improvements like this are coming in the next release. Increasingly, this will be the advocated alternative to TPUMP and Multiload.