accential 8.1

View previous topic View next topic Go down

accential 8.1

Post  ramakrishna on Wed Nov 16, 2011 1:32 pm

in accential 8.1 we are running dimension jobs but these jobs are getting aborted due to deadlock.As we use scd type-2 dimension which has two drs stages one for updating the old records and other for inserting the new records for the same table in same job.So how to avoid deadlock, what should be the array size and transaction size and what transaction isolation should be used to avoid such deadlocks.
thanks
ramakrishna

ramakrishna

Posts : 5
Join date : 2011-09-07
Age : 28
Location : chennai

View user profile

Back to top Go down

Re: accential 8.1

Post  ngalemmo on Wed Nov 16, 2011 2:58 pm

The two connections are operating under different transactions. Write the inserts to another table and append the table after all other processing has completed (transactions committed).
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: accential 8.1

Post  ramakrishna on Fri Nov 18, 2011 2:10 pm

we need to update and insert into same table..there is no other way..we use db2 database. So there are two actions going simultaneously on same table so we want to avoid deadlock. actually in 7.1 version the jobs ran successfully but the same job getting deadlock error in 8.1 version.

ramakrishna

Posts : 5
Join date : 2011-09-07
Age : 28
Location : chennai

View user profile

Back to top Go down

Re: accential 8.1

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum