Parallel job Hanging

[phanee_k]

Hi,
We are trying to load data into teradata using Teradata plugin.
We are using TPUMP to load the data.

Job is running fine if it has to process more than 10 records.

Sometimes , as part of delta process it is possible for the job to process less than 10 records.
At this point of time , the job is hanging .

If we stop the job at that moment and again restart the job, it is completing the process.

Are there any parameters that we need to set on AIX box to overcome this issue.

Appreciate your thoughts on this.

Thanks,
Phani

[kumar_s]

Isolate your issue.
First try to replace the teradata stage with Sequential stage. Check whether the performance increses.
If yes, try to load your table with manual mode.
If rate of the speed changes, check the commit interval, transaction log, mode of your load.