Home | Previous Page | Next Page   Database Reference > Configuration Parameters >

LOCKS

onconfig.std
value
2,000
range of values
2,000 through 8,000,000 on 32-bit platforms and 2,000 through 16,000,000 on 64-bit platforms
takes effect
When shared memory is initialized
refer to
The memory and locking chapters in your IBM Informix: Performance 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.

Tip:
When you drop a database, a lock is acquired and held on each table in the database until the database is dropped. For more information on the DROP DATABASE statement, see the IBM Informix: Guide to SQL Syntax.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]