The following parameters in the database server configuration file significantly affect memory utilization:
The SHMBASE parameter indicates the starting address for database server shared memory. When set according to the instructions in the machine notes file or release notes file, this parameter has no appreciable effect on performance. For the pathname of each file, see the Introduction to this guide.
The DS_NONPDQ_QUERY_MEM parameter increases the amount of memory that is a available for non-PDQ queries. You can only use this parameter if PDQ priority is set to zero. For more information, see More Memory for Queries with Hash Joins, Aggregates, and Other Memory-Intensive Elements.
The following sections describe the performance effects and considerations associated with some of the configuration parameters that are listed at the beginning of this section. For more information about these parameters, see the IBM Informix: Dynamic Server Administrator's Reference.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]