>>I have and old Fox 2.5 DOS program to update quantities in three tables using another table with the new quantities using SCAN and REPLACE.
>>
>>Recently I added to it Transactions, Buffering and normally it work very well.
>>
>>Today I had to update 501 records. The first 500 were ok, but with the record 501 I had a error message "that somebody was the table". I change the record order and always the problem was in the last register.
>>
>>I run the program with a database copy on a local drive and it runs correctly
>>Also I erase buffering and Transaction and the program works perfectly on the netware
>>
>>I think there is a Novell parameter. but I have no idea what it is.
>>
>>TIA
>
>
>You could try to change the AUTOEXEC.NCF on the Novell server
>
>
>add the following line or type it from system console screen
>
>SET MAXIMUM RECORD LOCKS PER CONNECTION=10000
>
>I think that default is 500 and maximum 10000
>
>Hope this will help
>zoran@dunavel.com
Thanks, I changed the parameter to 400,000 (It's old value was 20,000) and the problem is the same
I looked at server console and saw the next message:
Se excedió el umbral de bloqueo de registros 17. Total de violaciones 1027.
The threshold exceeded the lock records 17. Total violation number 1027
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only