Use the following parameters to control how space is allocated in shared memory.
| Configuration Parameter | Description |
|---|---|
| BUFFERPOOL | Specifies information about the buffer pool that must be
defined for each different page size that a dbspace uses. See Creating a Dbspace with a Non-Default Page Size.
Information that was specified with the BUFFERS, LRUS, LRU_MAX_DIRTY, and LRU_MIN_DIRTY configuration parameters prior to Version 10.0 is now specified using the BUFFERPOOL configuration parameter. |
| CKPTINTVL | Specifies the maximum time interval allowed to elapse before a checkpoint. For more information, see Physical Logging, Checkpoints, and Fast Recovery. |
| DD_HASHMAX | Specifies the maximum number of entries for each hash bucket in the data-dictionary cache. For more information about setting DD_HASHMAX, see your IBM Informix Performance Guide. |
| DD_HASHSIZE | Specifies the number of hash buckets in the data-dictionary cache. For more information about setting DD_HASHSIZE, see your IBM Informix Performance Guide. |
| DEF_TABLE_
LOCKMODE |
Sets the lock mode to page or row for new tables. For more information, see the IBM Informix Guide to SQL: Tutorial. |
| LOCKS | Specifies the initial number of locks available to database server user processes during transaction processing. For more information, see Managing Shared Memory and your IBM Informix Dynamic Server Performance Guide. |
| PC_POOLSIZE | Specifies the number of UDRs (both SPL routines and external routines) that can be stored in the UDR cache. For more information about setting PC_POOLSIZE, see your IBM Informix Dynamic Server Performance Guide. |
| PC_HASHSIZE | Specifies the number of hash buckets for the UDR cache. For more information about setting PC_HASHSIZE, see your IBM Informix Dynamic Server Performance Guide. |
| RESIDENT | Specifies whether shared-memory residency is enforced. For more information, see Managing Shared Memory and your IBM Informix Dynamic Server Performance Guide. |
| STACKSIZE | Specifies the stack size for database server user threads. For a discussion of the use of stacks, see Stacks. |