This chapter contains information about the database server configuration parameters that can be tuned to improve the efficiency of resource use.
This chapter describes the following tuning parameters:
This chapter does not include advice about the basic configuration parameters that you need to set to start a database server with its default values. For information about basic configuration parameters, refer to the chapter that describes setting up a database server in the IBM Informix: Extended Parallel Server Administrator's Guide.
In addition, for detailed information about the syntax of the database configuration parameters, refer to the IBM Informix: Extended Parallel Server Administrator's Reference.
When you adjust configuration parameters described in this chapter, consider the following goals:
For information about read-cache tuning, see Tuning BUFFERS to Improve the Read-Cache Rate. For information about write-cache tuning, see Tuning Write-Cache Rates.
For information, see Managing Checkpoints.
For information, see Specifying Logical Recovery Configuration Parameters.
For information, see Managing Checkpoints.
For additional information about tuning global configuration parameter settings and setting session-specific environment options, see Tuning Database Server Performance.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]