sometimes in our system Tpump sessions hangs and dba typically clears out the sessions by aborting it and then rerun works to completions..
There are multiple instances in a month that this occurs.
In order to find out why the session gets hanged can you give me some directions on what to look for?
Pointers are greatly appreciated.
When you say the sessions "hang", are they blocked, idle, something else?
Does it hang at start of load, part-way, or at end?
What is the target table structure? (Indexes, Join Indexes, partitioning, triggers, constraints, etc.)
If the problem is blocking / deadlock, be sure you are using SERIALIZE on a subset of PI columns (and no other columns).