Database Configuration Parameter Tuning and Monitoring
The database configuration parameters have an effect on the database, as well as on all applications that access the database. The parameters listed in Table 8.3 have the most significant impact on the performance of the database and its applications.
| Parameter | Description |
|---|---|
| BUFFPAGE | Default Buffer Pool Size |
| LOGBUFSZ | Log Buffer Size |
| APPLHEAPSZ | Application Heap Size |
| SORTHEAP | Sorting |
| SHEAPTHRES_SHR | Sorting |
| LOCKLIST | Locking |
| MAXLOCKS | Locking |
| NUM_IOCLEANERS | Number of Asynchronous Page Cleaners |
| NUM_IOSERVERSW | Number of I/O Servers |
| MINCOMMIT | Number of Commits to Group |
| CATALOGCACHE_SZ | Catalog Cache Size |
| CHNGPGS_THRESH | Changed Pages Threshold |
| AVG_APPLS | Average Number of ... |
Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® 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.
