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