Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 01 Jan 2010 @ 11:10:31 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Row Hash Deadlock in Active D/W due to concurrent MSR
From:   DWellman

Hi Suhail,

Have you tried using the "locking row for read" modifier on your MSR's ? (Although I've just thought that this may not work because you are using MSR's).

If the above won't work because of MSR's then you may need to split your MSR into multiple statements, each precded by a "locking row for ???" modifier. You can still maintain your transaction integrity by using BT and ET (or COMMIT WORK if you're using ANSI mode).

I'm not sure why Locking Logger doesn't capture all requests. What have you got set in DBSControl for the various locking logger fields ? Also, what release of TD are you on ?



Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023