Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2008 @ 16:47:52 GMT

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

Bill-

This error is typically caused by sessions running in ANSI mode failing to COMMIT their work.

If you have access to:

www.teradata.com/services-support/teradata-at-your-service

check out the following Knowledge Articles:

S11000DE0EA - Error message 2971: The AMP Lock table has overflowed. KAP195286 - "2971: The AMP Lock table has overflowed" caused by Insert Select into a Volatile Table that contains a USI

The first article has a great explanation of the problem and provides analysis tips and a script to help identify the root cause. The second article is the most recent issue we've uncovered but it is pretty specific.

-dave.clark

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