LOCKS

onconfig.std value

2,000

units

Number of locks in the internal lock table

range of values

2,000 through 8,000,000

takes effect

When the database server is shut down and restarted

utilities

onstat -k (See page onstat -k.)

refer to

The following material:

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

LOCKS specifies the initial size of the lock table. The lock table holds an entry for each lock that a session uses. If the number of locks that sessions allocate exceeds the value of LOCKS, the database server increases the size of the lock table.

Although each additional lock takes up just 44 bytes of resident shared memory, locks can become a resource drain if you have a limited amount of shared memory. For example, if you set LOCKS to 1,000,000, the database server allocates 40 megabytes of resident shared memory for locks.