ETL jobs hanging

General
Enthusiast

ETL jobs hanging

Hi,

We do have a below update query, we do not have any PI or USI in WHERE clause.

UPDATE target_table SET col_b = :a WHERE col_c = :ix;

We do execute the above query from DataStage.

They are 30 countries which are started in intervals of 1 minute.

Most of the time ETL jobs use the above query at a time which results in hanging.
Due to which each ETL job will take long time to complete.

Please let me know any resolution/suggestion for this.

Thank You,
2 REPLIES
Enthusiast

Re: ETL jobs hanging

Do you have Explain plan for the same.
Enthusiast

Re: ETL jobs hanging

A few questions to help get a better understanding of the situation and may to spark some more conversation:

How many iterations of this update statement are being run as part of the ETL job?
Are you updating a primary index field or otherwise indexed column?
Do you have RI constraints in place on this table (particularly this column)?
Are you seeing blocking (deadlock) issues in Teradata Manager or Viewpoint created by the overlapping intervals as a result of the "poor" performance of the original update?