All Forums Database
10 Jul 2013
Performance tuning for a tpump script-

Hi Experts,
There is a tpump which is taking 10 hours to process 7000 records, whcih earlier was taking 1 hour..  not sure why its taking 
so long now. the script cotains the normal insert select statement. 
just want to know that is there any optimal parametrs setting for the various TPUMP parameters..
like 
PACK
SESSIONS
ROBUST
SERIALIZE
currently its
PACK 10
SESSIONS 4
SERIALISE OFF
 
 
thanks in advance!
cheers!
Nishant
 

dnoeth 4628 posts Joined 11/04
10 Jul 2013

Hi Nishant,
7000 records in 1 hour? My TD Express should load that within a few seconds.
Did you check if there were locks/deadlocks? Better use SERIALZE on the PI columns.
Is the target table SET and has a large number of rows per value? Then there might be duplicate row check.
Otherwise the most important setting is ARRAYSUPPORT ON, then PACK might be set to the maximum (don't use PACKMAXIMUM within your daily load, just for testing to determine the actual maximum number).
ROBUST OFF (If the table is SET or has a UPI)
Could you share the script and DDL?
Dieter

Dieter

You must sign in to leave a comment.