You can use a text editor to set shared-memory configuration parameters at any time. Use the editor to locate the parameter in the ONCONFIG file, enter the new value or values, and rewrite the file to disk. Before the changes take effect, however, you must reinitialize shared memory.
Table 17 lists the parameters in the ONCONFIG file that specify the configuration of the buffer pool and the internal tables in the resident portion of shared memory. For a description of the configuration parameters, refer to the IBM Informix: Administrator's Reference.
| ONCONFIG
Parameter |
Purpose |
|---|---|
| BUFFERS | Specifies the maximum number of shared-memory buffers |
| ISOLATION_LOCKS | Specifies the maximum number of rows that can be locked on a single scan when Cursor Stability isolation level is in effect. For performance considerations when using this ISOLATION_LOCKS parameter, refer to your IBM Informix: Performance Guide. |
| LOCKS | Specifies the initial number of locks for database objects; for example, rows, key values, pages, and tables |
| LOGBUFF | Specifies the size of the logical-log buffers |
| PHYSBUFF | Specifies the size of the physical-log buffers |
| RESIDENT | Specifies residency for the resident portion of the database server shared memory |
| SERVERNUM | Specifies a unique identification number for the database server on the local host computer |
| SHMTOTAL | Specifies the total amount of memory to be used by the database server |