InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:12:48 GMT20http://www.teradata.com/teradataforum/Topic12437-9-1.aspxHi Tim,Please see the attached document. Hope this will answer your queries.Thanks & Regards,Thu, 11 Sep 2008 17:25:22 GMTShaheryar Iqbal -- Luminitehttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxThanks for all the info guys!Wed, 27 Aug 2008 10:23:07 GMTSchmoThttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxI believe you alluded to the remedy in your initial message in this topic. As a matter of application design, the number of locks held by a given transaction must be controlled.I don't know why the topic is not covered in the user manuals. Fri, 22 Aug 2008 17:38:36 GMTJim Chapmanhttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxWhy is that exactly? How do I avoid/remedy this situation?Thu, 21 Aug 2008 17:00:23 GMTSchmoThttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxYou won't find that documented in any of the customer manuals.Thu, 14 Aug 2008 14:09:21 GMTJim Chapmanhttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxYes. That is the error I get. I found the error description in the Messages User Guide. However, I'd like to see where the definition of each AMP having 2MB for locks is found. In what manual can I find that information?Thu, 14 Aug 2008 09:25:00 GMTSchmoThttp://www.teradata.com/teradataforum/Topic12437-9-1.aspx2971 The AMP Lock table has overflowed.Explanation: The lock table segment has overflowed.Generated By: LokMangr.For Whom: End User.Remedy: Wait until some transactions are finished, then resubmit the request.Fri, 08 Aug 2008 11:46:04 GMTatadarethttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxIn what manual can I find this information?Tue, 05 Aug 2008 17:24:06 GMTSchmoThttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxThe "lock table" (actually an in-memory data structure) has a fixed size of 2MB in each AMP. The total lock capacity of the system can be increased only by increasing the number of AMPs in the system.Mon, 04 Aug 2008 18:24:19 GMTJim Chapmanhttp://www.teradata.com/teradataforum/Topic12437-9-1.aspxOur system has experienced AMP lock table overflows a few times last week. We have had the programmers adjust their code to avoid so many locks, but we were wondering if there are any type of database settings that can be adjusted to increase the amount of locks available. Contractors set up our database and I an still learning about administrative duties such as these. Any direction would be appreciated.Thanks.Mon, 04 Aug 2008 14:47:48 GMTSchmoT