DB2 Version 10.1 for Linux, UNIX, and Windows

Database manager configuration parameters

You can set database manager configuration parameters to control server process, how clients connect to the database, and memory sharing and allocation on the database server. This type of parameter affects DB2® at the instance level.

agent_stack_sz - Agent stack size configuration parameter
You can use this parameter to determine the amount of memory that is allocated by DB2 for each agent thread stack.
agentpri - Priority of agents configuration parameter
This parameter controls the priority given both to all agents, and to other database manager instance processes and threads, by the operating system scheduler. This priority determines how CPU time is given to the database manager processes, agents, and threads relative to the other processes and threads running on the machine.
alt_diagpath - Alternate diagnostic data directory path configuration parameter
This parameter allows you to specify the fully qualified alternate path for DB2 diagnostic information that is used when the primary diagnostic data path, diagpath, is unavailable.
alternate_auth_enc - Alternate encryption algorithm for incoming connections at server configuration parameter
This configuration parameter specifies the alternate encryption algorithm used to encrypt the user IDs and passwords submitted to a DB2 database server for authentication. Specifically, this parameter affects the encryption algorithm when the authentication method negotiated between the DB2 client and the DB2 database server is SERVER_ENCRYPT.
aslheapsz - Application support layer heap size configuration parameter
The application support layer heap represents a communication buffer between the local application and its associated agent. This buffer is allocated as shared memory by each database manager agent that is started.
audit_buf_sz - Audit buffer size configuration parameter
This parameter specifies the size of the buffers used when you audit the DB2 instance.
authentication - Authentication type configuration parameter
This parameter specifies and determines how and where authentication of a user takes place.
cf_diaglevel - diagnostic error capture level configuration parameter for the CF
This parameter specifies the type of diagnostic errors that will be recorded in the cfdiag*.log files
cf_diagpath - diagnostic data directory path configuration parameter for the CF
This parameter allows you to specify the fully qualified path for the diagnostic information file for the CF
cf_mem_sz - CF memory configuration parameter
This parameter controls the total memory that is used by the cluster caching facility, also known as CF.
cf_num_conns - Number of CF connections per member per CF configuration parameter
This parameter controls the initial size of the cluster caching facility (CF) connection pool.
cf_num_workers - Number of worker threads configuration parameter
The cf_num_workers parameter specifies the total number of worker threads on the cluster caching facility (CF). Worker threads are distributed among the communication adapter ports to balance the number of worker threads servicing requests on each interface.
catalog_noauth - Cataloging allowed without authority configuration parameter
This parameter specifies whether users are able to catalog and uncatalog databases and nodes, or DCS and ODBC directories, without SYSADM authority.
clnt_krb_plugin - Client Kerberos plug-in configuration parameter
This parameter specifies the name of the default Kerberos plug-in library to be used for client-side authentication and local authorization.
clnt_pw_plugin - Client userid-password plug-in configuration parameter
This parameter specifies the name of the userid-password plug-in library to be used for client-side authentication and local authorization.
cluster_mgr - Cluster manager name configuration parameter
This parameter enables the database manager to communicate incremental cluster configuration changes to the specified cluster manager.
comm_bandwidth - Communications bandwidth configuration parameter
This parameter helps the query optimizer determine access paths by indicating the bandwidth between database partition servers.
comm_exit_list - Communication buffer exit library list configuration parameter
This parameter specifies the list of communication buffer exit libraries that DB2 will use. A communication buffer exit library is a dynamically loaded library that vendor applications can use to gain access to and examine DB2 communication buffers used to communicate with client applications.
conn_elapse - Connection elapse time configuration parameter
This parameter specifies the number of seconds within which a network connection is to be established between DB2 members.
cpuspeed - CPU speed configuration parameter
This parameter reflects the CPU speed of the machine(s) the database is installed on.
date_compat - Date compatibility database configuration parameter
This parameter indicates whether the DATE compatibility semantics associated with the TIMESTAMP(0) data type are applied to the connected database.
dft_account_str - Default charge-back account configuration parameter
This parameter acts as the default suffix of accounting identifiers.
dft_monswitches - Default database system monitor switches configuration parameter
This parameter allows you to set a number of switches which are each internally represented by a bit of the parameter.
dftdbpath - Default database path configuration parameter
This parameter contains the default file path used to create databases under the database manager. If no path is specified when a database is created, the database is created under the path specified by the dftdbpath parameter.
diaglevel - Diagnostic error capture level configuration parameter
This parameter specifies the type of diagnostic errors that will be recorded in the db2diag log file.
diagpath - Diagnostic data directory path configuration parameter
This parameter allows you to specify the fully qualified primary path for DB2 diagnostic information.
diagsize - Rotating diagnostic and administration notification logs configuration parameter
This parameter helps control the maximum sizes of the diagnostic log and administration notification log files.
dir_cache - Directory cache support configuration parameter
This parameter determines whether the database, node and DCS directory files will be cached in memory.
discover - Discovery mode configuration parameter
You can use this parameter to determine what kind of discovery requests, if any, the client can make.
discover_inst - Discover server instance configuration parameter
You can use this parameter to specify whether this instance can be detected by DB2 discovery.
fcm_num_buffers - Number of FCM buffers configuration parameter
You can use this parameter to specify the number of 4KB buffers that are used for internal communications, referred to as messages, both among and within database servers.
fcm_num_channels - Number of FCM channels configuration parameter
This parameter specifies the number of FCM channels for each database partition.
fcm_parallelism - Internode communication parallelism configuration parameter
This parameter specifies the degree of parallelism that is used for communication (both control messages and data flow) between members within a DB2 instance.
fed_noauth - Bypass federated authentication configuration parameter
This parameter determines whether federated authentication will be bypassed at the instance.
federated - Federated database system support configuration parameter
This parameter enables or disables support for applications submitting distributed requests for data managed by data sources (such as the DB2 Family and Oracle).
federated_async - Maximum asynchronous TQs per query configuration parameter
This parameter determines the maximum number of asynchrony table queues (ATQs) in the access plan that the federated server supports. The mechanism of ATQs does not work in DB2 pureScale® environments.
fenced_pool - Maximum number of fenced processes configuration parameter
This parameter represents the number of threads cached in each db2fmp process for threaded db2fmp processes (processes serving threadsafe stored procedures and UDFs). For non-threaded db2fmp processes, this parameter represents the number of processes cached.
group_plugin - Group plug-in configuration parameter
This parameter specifies the name of the group plug-in library.
health_mon - Health monitoring configuration parameter
This parameter allows you to specify whether you want to monitor an instance, its associated databases, and database objects according to various health indicators.
indexrec - Index re-creation time configuration parameter
This parameter indicates when the database manager attempts to rebuild invalid indexes, and whether or not any index build is redone during rollforward or high availability disaster recovery (HADR) log replay on the standby database.
instance_memory - Instance memory configuration parameter
This parameter specifies the maximum amount of memory that can be allocated for a database partition if you are using DB2 database products with memory usage restrictions or if you set it to a specific value. Otherwise, the AUTOMATIC setting allows instance memory to grow as needed.
intra_parallel - Enable intrapartition parallelism configuration parameter
This parameter specifies whether or not database connections will use intrapartition query parallelism by default.
java_heap_sz - Maximum Java interpreter heap size configuration parameter
You can use this parameter to determine the maximum size of the heap that is used by the Java™ interpreter started to service Java DB2 stored procedures and UDFs.
jdk_path - Software Developer's Kit for Java installation path configuration parameter
You can use this parameter to specify the directory under which the Software Developer's Kit (SDK) for Java is installed. The Java SDK is used for running Java stored procedures and user-defined functions. The CLASSPATH and other environment variables used by the Java interpreter are computed from the value of this parameter.
keepfenced - Keep fenced process configuration parameter
This parameter indicates whether or not a fenced mode process is kept after a fenced mode routine call is complete. Fenced mode processes are created as separate system entities in order to isolate user-written fenced mode code from the database manager agent process. This parameter is only applicable on database servers.
local_gssplugin - GSS API plug-in used for local instance level authorization configuration parameter
This parameter specifies the name of the default GSS API plug-in library to be used for instance level local authorization when the value of the authentication database manager configuration parameter is set to GSSPLUGIN or GSS_SERVER_ENCRYPT.
max_connections - Maximum number of client connections configuration parameter
This parameter indicates the maximum number of client connections allowed per member.
max_connretries - Node connection retries configuration parameter
This parameter specifies the maximum number of times an attempt will be made to establish a network connection between two DB2 members.
max_coordagents - Maximum number of coordinating agents configuration parameter
You can use this parameter to limit the number of coordinating agents.
max_querydegree - Maximum query degree of parallelism configuration parameter
This parameter specifies the maximum degree of intrapartition parallelism that is used for any SQL statement executing on this instance of the database manager. An SQL statement will not use more than this number of parallel operations within a database partition when the statement is executed.
max_time_diff - Maximum time difference between members configuration parameter
This parameter specifies the maximum time difference that is permitted between members in a DB2 pureScale environment that are listed in the node configuration file.
maxagents - Maximum number of agents configuration parameter
This parameter has been deprecated since Version 9.5, but is still being used by pre-Version 9.5 data servers and clients. Any value specified for this configuration parameter will be ignored by the database manager in DB2 Version 9.5 or later releases.
maxcagents - Maximum number of concurrent agents configuration parameter
This parameter has been deprecated since Version 9.5, but is still being used by pre-Version 9.5 data servers and clients. Any value specified for this configuration parameter will be ignored by the database manager in DB2 Version 9.5 or later releases.
mon_heap_sz - Database system monitor heap size configuration parameter
This parameter determines the amount of the memory, in pages, to allocate for database system monitor data. Memory is allocated from the monitor heap when database monitoring activities are performed such as turning on monitor switches, resetting monitor data, activating an event monitor or sending monitor events to an active event monitor.
nodetype - Instance node type configuration parameter
This parameter specifies the type of instance (the type of database manager) created by DB2 products installed on your machine.
notifylevel - Notify level configuration parameter
This parameter specifies the type of administration notification messages that are written to the administration notification log.
num_initagents - Initial number of agents in pool configuration parameter
You can use this parameter to determine the initial number of idle agents that are created in the agent pool when the db2start command is issued.
num_initfenced - Initial number of fenced processes configuration parameter
This parameter indicates the initial number of non-threaded, idle db2fmp processes that are created in the db2fmp pool at START DBM time.
num_poolagents - Agent pool size configuration parameter
This parameter sets the maximum size of the idle agent pool.
numdb - Maximum number of concurrently active databases including host and System i databases configuration parameter
This parameter specifies the number of local databases that can be concurrently active, or the maximum number of different database aliases that can be cataloged on a DB2 Connect™ server.
query_heap_sz - Query heap size configuration parameter
This parameter specifies the maximum amount of memory that can be allocated for the query heap, ensuring that an application does not consume unnecessarily large amounts of virtual memory within an agent.
release - Configuration file release level configuration parameter
This parameter specifies the release level of the configuration file.
rstrt_light_mem - Restart light memory configuration parameter
This parameter specifies the maximum amount of memory that is allocated and reserved on a host for restart light recovery purposes. The amount is a percentage of instance_memory configuration parameter.
resync_interval - Transaction resync interval configuration parameter
This parameter specifies the time interval in seconds for which a transaction manager (TM), resource manager (RM) or sync point manager (SPM) should retry the recovery of any outstanding indoubt transactions found in the TM, the RM, or the SPM.
rqrioblk - Client I/O block size configuration parameter
This parameter specifies the block size at the Data Server Runtime Client when a blocking cursor is opened.
sheapthres - Sort heap threshold configuration parameter
This parameter is an instance-wide soft limit on the total amount of memory that can be consumed by private sorts at any given time. When the total private sort memory consumption for an instance reaches this limit, the memory allocated for additional incoming private sort requests is considerably reduced.
spm_log_file_sz - Sync point manager log file size configuration parameter
This parameter identifies the sync point manager (SPM) log file size in 4 KB pages.
spm_log_path - Sync point manager log file path configuration parameter
This parameter specifies the directory where the sync point manager (SPM) logs are written.
spm_max_resync - Sync point manager resync agent limit configuration parameter
This parameter identifies the number of agents that can simultaneously perform resync operations.
spm_name - Sync point manager name configuration parameter
This parameter identifies the name of the sync point manager (SPM) instance to the database manager.
srvcon_auth - Authentication type for incoming connections at the server configuration parameter
This parameter specifies how and where user authentication is to take place when handling incoming connections at the server; it is used to override the current authentication type.
srvcon_gssplugin_list - List of GSS API plug-ins for incoming connections at the server configuration parameter
This parameter specifies the GSS API plug-in libraries that are supported by the database server. It handles incoming connections at the server when the srvcon_auth parameter is specified as KERBEROS, KRB_SERVER_ENCRYPT, GSSPLUGIN or GSS_SERVER_ENCRYPT, or when srvcon_auth is not specified, and authentication is specified as KERBEROS, KRB_SERVER_ENCRYPT, GSSPLUGIN or GSS_SERVER_ENCRYPT.
srvcon_pw_plugin - Userid-password plug-in for incoming connections at the server configuration parameter
This parameter specifies the name of the default userid-password plug-in library to be used for server-side authentication.
srv_plugin_mode - Server plug-in mode configuration parameter
This parameter specifies whether plug-ins are to run in fenced mode or unfenced mode. Unfenced mode is the only supported mode.
ssl_cipherspecs - Supported cipher specifications at the server configuration parameter
This configuration parameter specifies the cipher suites that the server allows for incoming connection requests when using SSL protocol.
ssl_clnt_keydb - SSL key file path for outbound SSL connections at the client configuration parameter
This configuration parameter specifies the key file to be used for SSL connection at the client-side.
ssl_clnt_stash - SSL stash file path for outbound SSL connections at the client configuration parameter
This configuration parameter specifies the fully qualified file path of the stash file to be used for SSL connections at the client-side.
ssl_svr_keydb - SSL key file path for incoming SSL connections at the server configuration parameter
This configuration parameter specifies the key file to be used for SSL setup at server-side.
ssl_svr_label - Label in the key file for incoming SSL connections at the server configuration parameter
This configuration parameter specifies a label of the personal certificate of the server in the key database.
ssl_svr_stash - SSL stash file path for incoming SSL connections at the server configuration parameter
This configuration parameter specifies a fully qualified file path of the stash file to be used for SSL setup at server-side.
start_stop_time - Start and stop timeout configuration parameter
This parameter specifies the time, in minutes, within which all database partition servers must respond to a START DBM or a STOP DBM command. It is also used as the timeout value during ADD DBPARTITIONNUM and DROP DBPARTITIONNUM operations.
ssl_svcename - SSL service name configuration parameter
This configuration parameter specifies the name of the port that a database server uses to await communications from remote client nodes using SSL protocol.
ssl_versions - Supported SSL versions at the server configuration parameter
This configuration parameter specifies Secure Sockets Layer (SSL) and Transport Layer Security (TLS) versions that the server supports for incoming connection requests.
svcename - TCP/IP service name configuration parameter
This parameter contains the name of the TCP/IP port which a database server will use to await communications from remote client nodes. This name must be the reserved for use by the database manager.
sysadm_group - System administration authority group name configuration parameter
This parameter defines the group name with SYSADM authority for the database manager instance.
sysctrl_group - System control authority group name configuration parameter
This parameter defines the group name with system control (SYSCTRL) authority. SYSCTRL has privileges allowing operations affecting system resources, but does not allow direct access to data.
sysmaint_group - System maintenance authority group name configuration parameter
This parameter defines the group name with system maintenance (SYSMAINT) authority.
sysmon_group - System monitor authority group name configuration parameter
This parameter defines the group name with system monitor (SYSMON) authority.
tm_database - Transaction manager database name configuration parameter
This parameter identifies the name of the transaction manager (TM) database for each DB2 instance.
tp_mon_name - Transaction processor monitor name configuration parameter
This parameter identifies the name of the transaction processing (TP) monitor product being used.
trust_allclnts - Trust all clients configuration parameter
This parameter and trust_clntauth are used to determine where users are validated to the database environment.
trust_clntauth - Trusted clients authentication configuration parameter
This parameter specifies whether a trusted client is authenticated at the server or the client when the client provides a userid and password combination for a connection.
util_impact_lim - Instance impact policy configuration parameter
This parameter allows the database administrator (DBA) to limit the performance degradation of a throttled utility on the workload.
wlm_dispatcher - Workload management dispatcher configuration parameter
This parameter enables (YES) or disables (NO) the DB2 workload management dispatcher. By default, an enabled dispatcher allows the setting of the CPU limits.
wlm_disp_concur - Workload manager dispatcher thread concurrency configuration parameter
This parameter specifies how the DB2 workload manager (WLM) dispatcher sets the thread concurrency level. You can also manually set the thread concurrency level to a fixed value.
wlm_disp_cpu_shares - Workload manager dispatcher CPU shares configuration parameter
This parameter enables (YES) or disables (NO) the control of CPU shares by the DB2 workload manager (WLM) dispatcher. By default, an enabled WLM dispatcher controls only CPU limits.
wlm_disp_min_util - Workload manager dispatcher minimum CPU utilization configuration parameter
This parameter specifies the minimum amount of CPU utilization that is necessary for a service class to be included in the DB2 WLM-managed sharing of CPU resources.