All Forums Tools
dsnaveen 6 posts Joined 07/10
04 Oct 2010
ETL jobs hanging


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 (ETL tool)

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,

You must sign in to leave a comment.