Record Lock Threshold exceeded , NEED HELP FAST

[niki43]

while posting a large amount of year end accouting files the 5.1 server gave the following error : "Station 18 , record lock threshold exceeded" . Where do I adjust the max record lock per station or per user?

 

[salserocito]

Here are the SET-parameters you need to modify:

(the default values are for NW4.11)
Maximum Record Locks Per Connection (default: 500, range 10 - 100000)
Maximum File Locks Per Connection (default :250, range 10 - 1000)
Maximum Record Locks (default :20000, range 100 - 400000)
Maximum File Locks (default: 10000, range 100-100000)

A rule of thumb is to double the parameters and monitor if the problem persists.

This means if parameters were set at default, the parameters should be changed at the server console to:
SET Maximum Record Locks Per Connection=1000
SET Maximum File Locks Per Connection=500
SET Maximum Record Locks=40000
SET Maximum File Locks=20000

The parameters can be set in startup.ncf or MONITOR.NLM/SERVER PARAMETERS to make these changes permanent.

Good Luck!

 

[spi200]

I had this same problem - You may need to max out the settings which are also in Monitor.

 

[niki43]

I want to thank everyone for you help, it was a life saver

 

[salserocito]

Glad we could be of assistance!!!

Good Luck!