salconen
asked on
Record Lock Threshold exceeded total violation 656
Hi, I'm currently running an foxpro application in novell 3.12 version. While run a particular option in the application I would get an error message from the application. "Record in used by another". I then checked the console of the novell server and got the above "error message" Pls help ...
ASKER
Yes I did release it before getting new ones. Would it be the network sides ??
At what time???
Is there backups being done?
Is there a batch file waiting to be process then executed at night???
I think the max for locked is 10,000 locks.
Is there backups being done?
Is there a batch file waiting to be process then executed at night???
I think the max for locked is 10,000 locks.
You've got to have a logical error somewhere. If you monitor the task from RCONSOLE/MONITOR I think you'll see it locking and locking and locking...
Sometimes you need to wait a bit tween lock release and new requests. Give the server time to digest. Try setting TRUE COMMIT ON in the NET.CFG file. This will prevent the server from pre-acknowledging writes until the disk has really written them.
M
Sometimes you need to wait a bit tween lock release and new requests. Give the server time to digest. Try setting TRUE COMMIT ON in the NET.CFG file. This will prevent the server from pre-acknowledging writes until the disk has really written them.
M
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi jsyring got your setting, where do I have to set it and what is the syntax to set them... Pls reply as soon as possible
Thanks
Thanks
Salconen
All of the settings can be set in the startup.ncf file and the syntax to set them is as follows
Set Maximum Record Locks Per Connection 1000
Set Maximum File Locks Per Connection 500
I have doubled the default in each setting and would then monitor the problem. You can then set the paramaters higher if you need to. Each of these setting may effect performance so I would not go any higher thean you need to.
All of the settings can be set in the startup.ncf file and the syntax to set them is as follows
Set Maximum Record Locks Per Connection 1000
Set Maximum File Locks Per Connection 500
I have doubled the default in each setting and would then monitor the problem. You can then set the paramaters higher if you need to. Each of these setting may effect performance so I would not go any higher thean you need to.
ASKER
yeah... you're right. but the lines need to entered in the autoexec.ncf
M