Maximum lock list: (MAXLOCKS).
最大锁列表(MAXLOCKS)。
When setting MAXLOCKS, consider the size of the lock list (LOCKLIST).
设置MAXLOCKS时,请考虑锁列表的大小(LOCKLIST)。
Locking memory (controlled by the locklist and maxlocks configuration parameters).
锁定内存(由locklist和maxlocks配置参数控制)。
The MAXLOCKS parameter multiplied by the MAXAPPLS parameter cannot be less than 100.
MAXLOCKS参数乘以MAXAPPLS参数不能小于100。
Use default locking, but have small values for the LOCKLIST and MAXLOCKS database configuration parameters.
使用缺省锁,但是让LOCKLIST和MAXLOCKS数据库配置参数的值比较小。
If not, lock escalation continues until the percentage of the lock list held is below the value of MAXLOCKS.
否则,锁升级就会一直进行,直到所持有的锁列表百分比低于MAXLOCKS。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
如果用一个表锁替换这些行锁,将不再会超出maxlocks值,那么锁升级就会停止。
Ensure that locklist and maxlocks are large enough, or else reduce the unit of work by issuing commit statements more often.
确保locklist和maxlocks足够大,或者通过更为频繁地发出commit语句减小工作单元。
If lock escalations are causing performance concerns you may need to increase the value of LOCKLIST parameter or the MAXLOCKS parameter.
如果锁升级造成性能方面的问题,则可能需要增大LOCKLIST参数或MAXLOCKS参数的值。
MAXLOCKS defines a percentage of the lock list held by an application that must be filled before the database manager performs lock escalation.
MAXLOCKS定义了应用程序持有的锁列表的百分比,在数据库管理器执行锁升级之前必须填充该锁列表。
You can increase MAXLOCKS if only a few applications run concurrently, because there will not be a lot of contention for the lock list space under these conditions.
如果只有几个应用程序并发地运行,则可以增大 MAXLOCKS,因为在这些条件下锁列表空间中不会有太多争用。
You can increase MAXLOCKS if only a few applications run concurrently, because there will not be a lot of contention for the lock list space under these conditions.
如果只有几个应用程序并发地运行,则可以增大 MAXLOCKS,因为在这些条件下锁列表空间中不会有太多争用。
应用推荐