![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 22 Mar 2013 @ 21:53:11 GMT
Subj: | | Session mode & 2971: The AMP Lock table has overflowed |
|
From: | | Bakthavachalam, Roopalini |
Hi Forum,
I read another post on this error (Link given below) and understood the reason behind it. I also read the knowledge article in T@YS. I
understand when you run the session in ANSI, you get this error when there are millions of transactions trying to acquire a row hash lock and the
AMP lock table runs out of resources. Does this error also occur when the session mode in ODBC driver is ?system default?.
www.teradataforum.com/teradata/20080320_164752.htm
Thanks
Roopalini
| |