When setting MAXLOCKS, consider the size of the lock list (LOCKLIST).
设置MAXLOCKS时,请考虑锁列表的大小(LOCKLIST)。
LOCKLIST indicates the amount of storage that is allocated to the lock list.
LOCKLIST表明分配给锁列表的存储容量。
Locking memory (controlled by the locklist and maxlocks configuration parameters).
锁定内存(由locklist和maxlocks配置参数控制)。
For example, the locklist is a memory pool that belongs to the database Shared memory set.
例如,locklist是属于数据库共享内存集的一个内存池。
Use default locking, but have small values for the LOCKLIST and MAXLOCKS database configuration parameters.
使用缺省锁,但是让LOCKLIST和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参数的值。
If the "LOCK list memory in use (Bytes)" exceeds 50 percent of the defined LOCKLIST size, then increase the number of 4kb pages in the LOCKLIST database configuration parameter.
如果“LOCKlistmemoryinuse (Bytes)”超过定义的LOCKLIST大小的50%,那么就增加LOCKLIST数据库配置参数中的4k b页的数量。
If the "LOCK list memory in use (Bytes)" exceeds 50 percent of the defined LOCKLIST size, then increase the number of 4kb pages in the LOCKLIST database configuration parameter.
如果“LOCKlistmemoryinuse (Bytes)”超过定义的LOCKLIST大小的50%,那么就增加LOCKLIST数据库配置参数中的4k b页的数量。
应用推荐