Tpump sessions hang

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Highlighted
KN
Enthusiast

Tpump sessions hang

Hello Gurus

 

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.

 

regards

KN

1 REPLY 1
Teradata Employee

Re: Tpump sessions hang

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).