Agent, process model, and memory configuration overview

Db2® data servers exploit multithreaded architecture on both 32-bit and 64-bit platforms to provide you with a number of benefits, such as enhanced usability, better sharing of resources, memory footprint reduction, and consistent threading architecture across all operating systems.

The following table lists the agent, process, and memory configuration topics by category:

Table 1. Overview of agent, process, and memory configuration information
Category	Related topics
General information, restrictions, and incompatibilities	Configuring memory and memory heaps Agent and process model configuration The Db2 Process Model Configuring databases across multiple partitions
Installation and upgrade	Connection concentrator Db2 Connect tuning Considerations for OS/390® and zSeries SYSPLEX exploitation Disk and memory requirements Modifying kernel parameters (Linux®) DB2® server behavior changes
Performance	Connection-concentrator improvements for client connections Database agents Database agent management Database manager shared memory Memory allocation in Db2 Tuning memory allocation parameters
Commands, APIs, registry variables, functions, and routines	db2pd - Monitor and troubleshoot DBb database command GET DATABASE MANAGER CONFIGURATION command RESET DATABASE MANAGER CONFIGURATION command UPDATE DATABASE MANAGER CONFIGURATION command db2mtrk - Memory tracker command Note: With the release of Db2 12.1, the db2mtrk command is discontinued. sqlfupd data structure System environment variables Shared file handle table Running vendor library functions in fenced-mode processes ADMIN_GET_MEM_USAGE table function - Get total memory consumption for instance SQL and XML limits SYSCAT.PACKAGES catalog view DBMCFG administrative view - Retrieve database manager configuration parameter information ADMIN_CMD procedure-Run administrative commands
Configuration parameters	Configuration parameters summary appl_memory - Application Memory applheapsz - Application heap size database_memory - Database shared memory size dbheap - Database heap instance_memory - Instance memory locklist - Maximum storage for lock list max_connections - Maximum number of client connections max_coordagents - Maximum number of coordinating agents maxappls - Maximum number of active applications mon_heap_sz - Database system monitor heap size num_poolagents - Agent pool size stat_heap_sz - Statistics heap size stmtheap - Statement heap size
Monitor elements	agents_from_pool - Agents Assigned From Pool agents_registered - Agents Registered agents_registered_top - Maximum Number of Agents Registered agents_stolen - Stolen Agents appls_in_db2 - Applications Executing in the Database Currently associated_agents_top - Maximum Number of Associated Agents coord_agents_top - Maximum Number of Coordinating Agents local_cons - Local Connections local_cons_in_exec - Local Connections Executing in the Database Manager num_gw_conn_switches - Maximum Agent Overflows rem_cons_in - Remote Connections To Database Manager rem_cons_in_exec - Remote Connections Executing in the Database Manager