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.

Table 16.2. Parameters with the Most Impact on System Performance for Configuring a DB2 Instance
Parameter NameDescription
RQRIOBLKMaximum requester I/O block size.
INTRA_PARALLELEnables intra-partition parallelism.
SHEAPTHRESSort heap threshold.
NUM_INITAGENTSInitial number of agents in pool.

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.