Home |
Previous Page | Next Page Database Reference > Configuration Parameters >
- 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 ]