Bookshelf v7.5: DB2 Database Manager Configuration Parameters

You can set the database configuration parameters using the update database manager configuration command of the DB2 Command Line Processor or using the DB2 Control Center.

NOTE: See the IBM DB2 technical documentation for more information on modifying the database configuration parameters.

Table 16 describes DB2 database manager configuration parameters that differ from the default settings. Set these parameters for each DB2 instance. Use the configuration information below for the listed parameters. For parameters not listed in this table, accept the default settings.

Table 16. DB2 Database Manager Configuration Parameters
Parameter	Explanation	Setting/Comment
`SHEAPTHRES`	Sort heap threshold (4 KB)	`100000` Deployments with 3,000 or more concurrent users and using over 5 GB of RAM can increase it to `300000.`
`DIR_CACHE`	Directory cache support	`YES`
`ASLHEAPSZ`	Application support layer heap size (4 KB)	`1024`
`RQRIOBLK`	Max. requester I/O block size (bytes)	`65535`
`MON_HEAP_SZ`	Database monitor heap size (4 KB)	`128` `(`minimum)
`QUERY_HEAP_SZ`	Query heap size (4 KB)	`16384`
`KEEPDARI`	Keep DARI process	`YES`
`MAXAGENTS`	Max. number existing agents	`1000` (minimum)
`NUM_INITAGENTS`	Initial number agents in pool	`10`
`NUM_POOLAGENTS`	Number of agents in the agent pool kept active at all times	`80`
`MAX_COORDAGENTS`	Max. number coordinating agents	`MAXAGENTS`
`INDEXREC`	Index re-creation time	`RESTART`
`MAX_QUERYDEGREE`	Max. query degree of parallelism	`1`
`INTRA_PARALLEL`	Enable intra-partition parallelism	`NO`