Set ONCONFIG tuning parameters
You can optimize the performance of text searches that
use etx indexes when you configure the following ONCONFIG tuning
parameters for HCL OneDB™:
| Tuning parameter | Description |
|---|---|
| AUTO_READAHEAD (HCL OneDB 11.70 and later) | The AUTO_READAHEAD parameter changes the automatic read-ahead mode or disables automatic read-ahead operations for a query. Use the AUTO_READAHEAD parameter to configure automatic read-ahead operations for all queries. |
| BUFFERPOOL | The BUFFERPOOL parameter defines a buffer pool for pages that correspond to each unique page size in use by your dbspaces. Use the BUFFERPOOL parameter to specify information about the buffer pool including its size, the number of LRUS in the buffer pool, the number of buffers in the buffer pool, and lru_min_dirty and lru_max_dirty values. |
| RA_THRESHOLD (HCL OneDB 11.70 and earlier) | The RA_THRESHOLD parameter specifies the number of unprocessed pages in memory that signals the database server to perform the next read ahead. |
| RESIDENT | The RESIDENT parameter specifies whether the
resident portion of shared memory remains resident in operating system
physical memory. If your operating system supports forced residency,
you can improve the performance of searches by specifying that the
resident portion of shared memory not be swapped to disk. To do this,
set this parameter to 1 (on). |
| VPCLASS noage | You can add the noage option when specify
the ETX VPCLASS to disable priority aging by the operating system
if the operating system implements priority aging. The noage option
for the VPCLASS parameter controls whether the operating system lowers
the priority of database server processes as the processes run over
a period. You can improve the performance of searches by setting this
option to noage. |
This section provides only a minimum of information about the ONCONFIG tuning parameters. Before you change your onconfig file, see the HCL OneDB Administrator's Reference for your database server for more detailed information about each parameter.