locking table when update and insert into one table
Posted: Wed Aug 25, 2010 3:09 am
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
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