LOCK이 동적으로 증가하는 개수 (11.50기준)

LOCKS Configuration Parameter

The LOCKS configuration parameter specifies the initial size of the lock table.

The lock table holds an entry for each lock. If the number of locks allocated exceeds the value of the LOCKS configuration parameter, the database server increases the size of the lock table. The lock table can be increased a maximum of 99 times.

onconfig.std value

20000

units

Number of locks in the internal lock table

range of values

2,000 through 8,000,000 for 32-bit database servers 2,000 through 500,000,000 for 64-bit database servers

takes effect

When the database server is shut down and restarted

utilities

onstat -k (see onstat -k command: Print active lock information.)

refer to

• The memory and locking chapters in your IBM® Informix® Performance Guide
• The shared memory chapter in the IBM Informix Administrator's Guide

The database server increases the size of the lock table by attempting to double the lock table on each increase. However, the amount added during each increase is limited to a maximum value. For 32-bit platforms, a maximum of 100,000 locks can be added during each increase. Therefore, the total maximum locks allowed for 32-bit platforms is 8,000,000 (maximum number of starting locks) + (99 (maximum number of dynamic lock table extensions) x 100,000 (maximum number of locks added per lock table extension). For 64-bit platforms, a maximum of 1,000,000 locks can be added during each increase. Therefore, the total maximum locks allowed is 500,000,000 (maximum number of starting locks) + (99 (maximum number of dynamic lock table extensions) x 1,000,000 (maximum number of locks added per lock table extension).

With the initial lock table stored in resident memory and each additional lock stored in virtual memory, locks can become a resource drain if you have a limited amount of shared memory. The amount of storage occupied by a single lock depends on the word size and operating system, and is subject to change. Currently, the amount of storage ranges from approximately 100 to 200 bytes. You can see the amount of storage required to support additional locks by restarting the server with a different value of the LOCKS configuration parameter (without making other changes), and observing the increase in memory used as shown by onstat -g mem" for the resident pool.

저만큼 크게 잡은 데를 본적은 없다. 10점대와 비교하면 증가하는 횟수에 차이가 있다

http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm.adref.doc%2Fids_adr_0094.htm&resultof="locks"%20

http://www.ibm.com/developerworks/data/library/techarticle/dm-0701herber/index.html