Teradata AMP lock table overflow

Database
Enthusiast

Teradata AMP lock table overflow

Our 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.
9 REPLIES
Enthusiast

Re: Teradata AMP lock table overflow

The "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.
Enthusiast

Re: Teradata AMP lock table overflow

In what manual can I find this information?
Enthusiast

Re: Teradata AMP lock table overflow

2971 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.
Enthusiast

Re: Teradata AMP lock table overflow

Yes. 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?
Enthusiast

Re: Teradata AMP lock table overflow

You won't find that documented in any of the customer manuals.
Enthusiast

Re: Teradata AMP lock table overflow

Why is that exactly? How do I avoid/remedy this situation?
Enthusiast

Re: Teradata AMP lock table overflow

I 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.

Enthusiast

Re: Teradata AMP lock table overflow

Thanks for all the info guys!

Re: Teradata AMP lock table overflow

Hi Tim,

Please see the attached document. Hope this will answer your queries.

Thanks & Regards,