Tpump Performance

Tools

Tpump Performance

Hi

I have a teradata Environment with 48 Amps , and I have a a table (sales_history) with 235.000.000 rows , I´m loading it with a Multiload utility , I want to change it for a tpump, but I, don´t have any experience with it, any Idea about the performance with tpump ?

Does anybody have idea (aprox) about the time used by tpump in order to load 60.000 rows ?
1 REPLY
hh
Enthusiast

Re: Tpump Performance

I hope the reason you want to use tpump is largely based on data avalability and not to replace mload entirely.

There are many tunable parameters for tpump but try those out like
-sessions
-pack rate
-latency
-keep the macros and not to generate it everytime (-m option when invoking tpump, then change the script to execute macro the second time)
-turn off access logging on the target table or user id.

We have relatively good performance (700-800 rows per second per node, mix update/insert) on the new 5400 nodes. Wide table does have some impact but not that much.

Hope it helps...