TPUMP ERROR DUE TO CONTENTION

Tools & Utilities
N/A

TPUMP ERROR DUE TO CONTENTION

Hi All,

I hope I am posting my problem in right forum.

I have two datastage jobs which inserts data into a same table using tpump utility. One of them fails when both the jobs triggers at the same time.

These datastage jobs first deletes data from the table based on a condition & then inserts data.

Also, same control file is used in both the jobs.

My gut feeling is because of same control file used in both the jobs or tpump in one of the job locking the table thus the other job is unable to access this table & fails.

Please let me know if you are aware of this & can guide me in finding the exact reason.

Shall appreciate early response from you.

TIA.