Archives of the TeradataForum

Message Posted: Fri, 01 Jan 2010 @ 19:54:38 GMT

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

Hi Sohail,

1. Are the MSR updates in a transaction?

2. If yes, is more than one such "update" MSR sent in the same transaction?

3. If possible, please provide the "explain" for the update of the complete MSR request, not just the "update" to .

4. Please also include "show" sql of the MSR, to get the index and RI information, if any.

5. Does the deadlock error happen with just two parallel runs of the "update" sql?

Thanks,

Kalyana

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