DB2 Version 9.7 for Linux, UNIX, and Windows

local_cons_in_exec - Local Connections Executing in the Database Manager monitor element

The number of local applications that are currently connected to a database within the database manager instance being monitored and are currently processing a unit of work.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database Manager	db2	Basic

Usage

This number can help you determine the level of concurrent processing occurring in the database manager. This value will change frequently, so you may need to sample it at specific intervals over an extended period of time to get a realistic view of system usage. This number only includes applications that were initiated from the same instance as the database manager.

When used in conjunction with the rem_cons_in_exec monitor element, this element can help you adjust the setting of the max_coordagents configuration parameter.

The following recommendations apply to non-concentrator configurations only. When concentrator is enabled, DB2® is multiplexing a larger number of client connections onto a smaller pool of coordinator agents. In this case, it is usually acceptable to have the sum of rem_cons_in_exec and local_cons_in_exec approach the max_coordagents value.

If max_coordagents is set to AUTOMATIC, do not make any adjustments.
If max_coordagents is not set to AUTOMATIC and if the sum of rem_cons_in_exec and local_cons_in_exec is close to max_coordagents, increase the value of max_coordagents.