Archives of the TeradataForum

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

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

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 ?

Cheers,

Dave

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

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