locking table when update and insert into one table

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
yimwai
Participant
Posts: 46
Joined: Thu Jul 01, 2010 9:34 pm

locking table when update and insert into one table

Post by yimwai »

How to avoid locking talbe when update and insert into one table at the same time .
The result data should be divided into two parts(two parts have no shared data) :
insert one part into table,and update the other into the same table.
i used transformer stage to get the result data and divide them into two parts through two lines to DB2 enterprise stages,
then the table is locked and the job keeps running forever...
how to handle this situation
can I make the DB2 enterprise stages(from one transformer) running in order or other good ideas
Post Reply