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..
thanks in advance!
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?