|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/7/2008 11:04:33 AM
Posts: 10,
Visits: 74
|
|
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.
Tim Schmolzi
Missouri Office of Administration
ITSD-DOR Database
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 12:52:50 PM
Posts: 217,
Visits: 454
|
|
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.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/7/2008 11:04:33 AM
Posts: 10,
Visits: 74
|
|
In what manual can I find this information?
Tim Schmolzi
Missouri Office of Administration
ITSD-DOR Database
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/17/2008 6:46:55 PM
Posts: 9,
Visits: 14
|
|
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.
Thanks,
atadaret
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/7/2008 11:04:33 AM
Posts: 10,
Visits: 74
|
|
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?
Tim Schmolzi
Missouri Office of Administration
ITSD-DOR Database
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 12:52:50 PM
Posts: 217,
Visits: 454
|
|
|
You won't find that documented in any of the customer manuals.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/7/2008 11:04:33 AM
Posts: 10,
Visits: 74
|
|
Why is that exactly? How do I avoid/remedy this situation?
Tim Schmolzi
Missouri Office of Administration
ITSD-DOR Database
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 12:52:50 PM
Posts: 217,
Visits: 454
|
|
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.
|
|
|
| | |