Performance Tuning for Content Manager

206 Performance Tuning for Content Manager

2. Run the DB2 command. (Refer to subsections for the specific

parameter-related command.)

3. Stop and start the database if it is not an online configurable parameter.

8.6.1 Intra-partition parallelism (INTRA_PARALLEL)

Impact

DBM - High

Description

This parameter specifies whether the database manager can use intra-partition

parallelism. If intra-partition parallelism is disabled (this is the default), then the

coordinator agent performs all the application’s requests. If intra-partition

parallelism is enabled, then DB2 assigns a set of subagents to the application to

work on processing the application’s requests. Some of the operations that can

take advantage of intra-partition parallelism include database queries and index

creation.

Default value

No

To update

Run the following DB2 command:

db2 update dbm cfg using INTRA_PARALLEL <parameter value>

Our recommendation

Keep this parameter as No. If INTRA_PARALLEL is set to Yes, for each

connection, DB2 splits SQL statements to be processed in parallel, causing the

Note: Much of the material in this section is extracted from the following

publications and augmented with our personal experiences:

 IBM DB2 Universal Database Version 8.2 Administration Guide: Planning,

SC09-4822

 IBM DB2 Universal Database Version 8.2 Administration Guide:

Performance, SC09-4821

 IBM DB2 Universal Database Version 8.2 System Monitor Guide and

Reference, SC09-4847

If you are interested in more in-depth understanding of DB2 and DB2 tuning,

we recommend reading these publications. They are excellent guides to DB2,

especially with regard to performance tuning.