16.5. Configuring Your Databases
The database configuration parameters affect all aspects of your database performance and all applications that access the database. This section examines the parameters that have the biggest impact on system performance and provides suggestions on how to choose the right value for the parameter.
Table 16.3 lists the parameters with the biggest impact on system performance.
| Parameter Name | Description |
|---|---|
| AVG_APPLS | Average number of active applications. |
| MINCOMMIT | Number of commits to group. |
| LOGBUFSZ | Size of the log buffer. |
| SORTHEAP | Memory available for sorts. |
| SHEAPTHRES_SHR | Shared sort heap threshold. |
| LOCKLIST | Memory available to store ... |
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.
