Performance Tuning for Content Manager

Chapter 8. Tuning DB2 for Content Manager 207

use of more agents and resources. If your system is transactional (several

connections), the recommendation is not to use INTRA_PARALLEL.

If you change this value, you must rebind all packages defined in that database.

8.6.2 Maximum number of concurrently active databases (NUMDB)

Impact

DBM - Low

Description

This parameter specifies the number of local databases that can be concurrently

active (that is, have applications connected to them), or the maximum number of

different database aliases that can be cataloged on a DB2 Connect™ server. In a

partitioned database environment, it limits the number of active database

partitions on a database partition server, regardless of whether that server is the

coordinator node for the application.

Default values (range)

8 (1 - 256) for UNIX and Windows database server with local and remote clients

3 (1 - 256) for Windows database server with local clients

To update

Run the following DB2 command:

db2 update dbm cfg using NUMDB <parameter value>

Our recommendation

DB2 allocates memory for each database during the database manager startup.

It is generally best to set this value to the actual number of databases that are

already defined to the database manager. In a general Content Manager system,

we set the parameter to 3:

 Library Server database

 Resource Manager database

 toolsdb database (this database is used to monitor DB2)