Caché Parameter File Reference
LockThreshold
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

SQL lock threshold.
Synopsis
[SQL]    LockThreshold=n
Description
The value n is the lock threshold. This is the number of inserts, updates, or deletes for a single table within a single transaction that will trigger a table-level lock when reached. For example, if the lock threshold is 1000 and a process starts a transaction and then inserts 2000 rows, after the 1001st row is inserted the process will attempt to acquire a table-level lock instead of continue to lock individual rows. This is to help keep the lock table from becoming too full.
Examples
LockThreshold=1000
Range of Values
Any integer. The default is 1000.
Management Portal
On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, in the Lock Threshold field, enter a number.