Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2008 @ 16:47:52 GMT
This error is typically caused by sessions running in ANSI mode failing to COMMIT their work.
If you have access to:
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|