Archives of the TeradataForum
Message Posted: Fri, 01 Jan 2010 @ 11:10:31 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|