Performance tuning for a tpump script-

Database

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

1 REPLY
N/A

Re: Performance tuning for a tpump script-

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