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.
agentpri - Priority 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 continue to work exactly as it did in previous versions, and
this parameter will continue to be fully supported.
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.
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.
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 nonthreaded db2fmp processes,
this parameter represents the number of processes cached.
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.
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.
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.
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 you perform database monitoring activities
such as taking a snapshot, turning on a monitor switch, resetting
a monitor, or activating an event monitor.
nodetype - Machine node type configuration parameter
This parameter provides information about the DB2 products which you have installed on your
machine and, as a result, information about the type of database manager
configuration.
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 size of the communication
buffer between remote applications and their database agents on the
database server. It is also used to determine the I/O 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.
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.
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 an ADD DBPARTITIONNUM
operation.
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.