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.

Table 16.3. Parameters with the Most Impact on System Performance for Configuring Your Database
Parameter NameDescription
AVG_APPLSAverage number of active applications.
MINCOMMITNumber of commits to group.
LOGBUFSZSize of the log buffer.
SORTHEAPMemory available for sorts.
SHEAPTHRES_SHRShared sort heap threshold.
LOCKLISTMemory available to store ...

Get Understanding DB2®: Learning Visually with Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.