16.4. Configuring the DB2 Instance
The Database Manager (instance-level) Configuration parameters affect the performance of all databases in the instance and all applications that access databases in the instance. This section examines the parameters that have the biggest impact on the system performance and gives suggestions on how to choose the right value for the parameter.
Table 16.2 lists the parameters with the biggest impact on system performance.
| Parameter Name | Description |
|---|---|
| RQRIOBLK | Maximum requester I/O block size. |
| INTRA_PARALLEL | Enables intra-partition parallelism. |
| SHEAPTHRES | Sort heap threshold. |
| NUM_INITAGENTS | Initial number of agents in pool. |
| NUM_POOLAGENTS ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
