Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

accential 8.1

Go down

accential 8.1 Empty accential 8.1

Post  ramakrishna 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 : 32
Location : chennai

Back to top Go down

accential 8.1 Empty Re: accential 8.1

Post  ngalemmo 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).
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

accential 8.1 Empty Re: accential 8.1

Post  ramakrishna 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 : 32
Location : chennai

Back to top Go down

accential 8.1 Empty Re: accential 8.1

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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