Discussion Locked

Record Lock Thresholds exceeded

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am running a Microsoft Access program which is installed on my Novell 4.11 server. Each time I start doing a tasking process like a period end I have a "Record lock Threshold exceeded. Total violations 15...." What do I need to adjust to avoid this problem?

5 replies

by larcat

Load Monitor
-Under Available Options-
go to server Parameters
go to Locks

My guess the Max Record locks per connections is set to about 500 - change this to least 10000.

by barbara r.

Had the exact same problem. It was fixed by adjusting the following settings under "LOCKS":

Max Record Locks Per Connection: 10000
Max File Locks Per Connection: 1000
Maximum Record Locks: 100000
Maximum File Locks: 2000

This discussion is closed to new replies.