Db2 database configuration parameters

Specify values for database configuration parameters to control the behavior of your database.

act_sortmem_limit - Activity sort memory limit configuration parameter
This parameter specifies the individual query sort memory limit for the database.
alt_collate - Alternate collating sequence configuration parameter
This parameter specifies the collating sequence that is to be used for Unicode tables in a non-Unicode database.
app_ctl_heap_sz - Application control heap size configuration parameter
In Version 9.5, app_ctl_heap_sz has been replaced by the appl_memory configuration parameter.
appgroup_mem_sz - Maximum size of application group memory set 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.
appl_memory - Application memory configuration parameter
The appl_memory configuration parameter specifies the size of the application memory set. The application memory size counts towards any instance_memory limit in effect.
applheapsz - Application heap size configuration parameter
The applheapsz configuration parameter refers to the total amount of application memory that can be consumed by the entire application.
archretrydelay - Archive retry delay on error configuration parameter
This parameter specifies the number of seconds to wait after a failed archive attempt before trying to archive the log file again.
auto_del_rec_obj - Automated deletion of recovery objects configuration parameter
This parameter specifies whether database log files, backup images, and load copy images should be deleted when their associated recovery history file entry is pruned.
auto_maint - Automatic maintenance configuration parameter
This parameter is the parent of all the other automatic maintenance database configuration parameters (auto_db_backup, auto_tbl_maint, auto_runstats, auto_stmt_stats, auto_stats_views, auto_reorg, auto_sampling, and auto_cg_stats).
auto_reval - Automatic revalidation and invalidation configuration parameter
This configuration parameter controls the revalidation and invalidation semantics.
autorestart - Auto restart enable configuration parameter
The autorestart configuration parameter determines if the database manager automatically initiates crash recovery when a user connects to a database that had previously terminated abnormally. If the autorestart configuration parameter is not set, the user must issue an explicit restart database command before they can connect to the database.
avg_appls - Average number of active applications configuration parameter
This parameter is used by the query optimizer to help estimate how much buffer pool space will be available at run time for the access plan chosen.
backup_pending - Backup pending indicator configuration parameter
The backup_pending parameter indicates whether you need to do a full backup of the database before accessing it.
blk_log_dsk_ful - Block on log disk full configuration parameter
This parameter can be set to prevent disk full errors from being generated when the Db2 database system cannot create a new log file in the active log path.
blocknonlogged - Block creation of tables that allow non-logged activity configuration parameter
This parameter specifies whether the database manager will allow tables to have the NOT LOGGED or NOT LOGGED INITIALLY attributes activated.
CF self-tuning memory database configuration parameter
In a Db2 pureScale® environment, this read-only database configuration parameter indicates whether CF self-tuning memory is enabled or not.
cf_catchup_trgt - Target for catch up time of secondary cluster caching facility configuration parameter
This configuration parameter determines the target time in minutes for completing the catch up to bring a newly added or newly restarted cluster caching facility into peer state with an existing primary cluster caching facility .
cf_db_mem_sz - Database memory configuration parameter
This parameter controls the total memory limit for the cluster caching facility, also designated as the CF, for this database.
cf_gbp_sz - Group buffer pool configuration parameter
This parameter determines the memory size used by the cluster caching facility, also known as CF, for group buffer pool (GBP) usage for this database.
cf_lock_sz - CF Lock manager configuration parameter
This parameter determines the memory size used by the CF for locking usage for this database.
cf_sca_sz - Shared communication area configuration parameter
This Shared Communication Area (SCA) configuration parameter determines the memory size used by the SCA in the cluster caching facility (CF). The SCA is a per database entity and contains database wide control block information for tables, indexes, table spaces, and catalogs.
catalogcache_sz - Catalog cache size configuration parameter
This parameter specifies the maximum space in pages that the catalog cache can use from the database heap.
chngpgs_thresh - Changed pages threshold configuration parameter
This parameter specifies the level (percentage) of changed pages at which the asynchronous page cleaners will be started, if they are not currently active.
codepage - Code page for the database configuration parameter
This parameter shows the code page that was used to create the database. The codepage parameter is derived based on the codeset parameter.
codeset - Codeset for the database configuration parameter
This parameter shows the codeset that was used to create the database. Codeset is used by the database manager to determine codepage parameter values.
collate_info - Collating information configuration parameter
This parameter determines the database's collating sequence. For a language-aware collation or locale-sensitive UCA collation, the first 256 bytes contain the string representation of the collation name (for example, "SYSTEM_819_US").
connect_proc - Connect procedure name database configuration parameter
This database configuration parameter allows you to input or update a two-part connect procedure name that will be executed every time an application connects to the database.
country/region - Database territory code configuration parameter
This parameter shows the territory code used to create the database.
cur_commit - Currently committed configuration parameter
This parameter controls the behavior of cursor stability (CS) scans.
database_consistent - Database is consistent configuration parameter
This parameter indicates whether the database is in a consistent state.
database_level - Database release level configuration parameter
This parameter indicates the release level of the database manager which can use the database.
database_memory - Database shared memory size configuration parameter
The database_memory configuration parameter specifies the size of the database memory set. The database memory size counts towards any instance memory limit in effect.
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.
dbheap - Database heap configuration parameter
You can use this parameter to limit the maximum amount of memory allocated for the database heap. Additional memory is automatically added for critical memory requirements.
db_mem_thresh - Database memory threshold configuration parameter
This parameter represents the maximum percentage of committed, but currently unused, database shared memory that the database manager will allow before starting to release committed pages of memory back to the operating system.
ddl_compression_def - DDL compression default configuration parameter
This parameter specifies the default value for the COMPRESS keyword of a CREATE TABLE statement.
ddl_constraint_def - Default constraint type configuration parameter
This parameter specifies the default constraint type.
dec_arithmetic - DECIMAL arithmetic mode configuration parameter
This parameter specifies the DECIMAL arithmetic mode. This mode affects the rules for result precision and scale of basic DECIMAL operators (+, -, *, /) and the AVG and SUM aggregate functions with a DECIMAL argument.
dec_to_char_fmt - Decimal to character function configuration parameter
This parameter is used to control the result of the CHAR scalar function and the CAST specification for converting decimal to character values.
decflt_rounding - Decimal floating point rounding configuration parameter
This parameter specifies the rounding mode for decimal floating point (DECFLOAT) values. The rounding mode affects decimal floating-point operations in the server, and in LOAD command operations.
dft_degree - Default degree configuration parameter
This parameter specifies the default value for the CURRENT DEGREE special register and the DEGREE bind option.
dft_extent_sz - Default extent size of table spaces configuration parameter
This parameter sets the default extent size of table spaces.
dft_loadrec_ses - Default number of load recovery sessions configuration parameter
This parameter specifies the default number of sessions that will be used during the recovery of a table load.
dft_mttb_types - Default maintained table types for optimization configuration parameter
This parameter specifies the default value for the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. The value of this register determines what types of refresh deferred materialized query tables will be used during query optimization.
dft_prefetch_sz - Default prefetch size configuration parameter
This parameter sets the default prefetch size of table spaces.
dft_queryopt - Default query optimization class configuration parameter
The query optimization class is used to direct the optimizer to use different degrees of optimization when compiling SQL and XQuery queries.
dft_refresh_age - Default refresh age configuration parameter
This parameter specifies the default value for the CURRENT REFRESH AGE special register. The value represents the maximum duration since a particular time-stamped event occurred to a cached data object. The cached data object can be used during this period to help optimize the processing of a query. An example of a time-stamped event is processing a REFRESH TABLE statement on a system-maintained REFRESH DEFERRED materialized query table.
dft_schemas_dcc - Default data capture on new schemas configuration parameter
This parameter allows the control of default setting for DATA CAPTURE CHANGES on newly created schemas for replication purposes.
dft_sqlmathwarn - Continue upon arithmetic exceptions configuration parameter
This parameter sets the value that determines the handling of arithmetic errors, such as division by zero, and retrieval conversion errors during SQL statement execution.
dft_table_org - Default table organization
This parameter specifies whether a user table is created as a column-organized table or a row-organized table if you do not specify the ORGANIZE BY COLUMN or the ORGANIZE BY ROW clause for the CREATE TABLE statement.
discover_db - Discover database configuration parameter
You can use this parameter to prevent information about a database from being returned to a client when a discovery request is received at the server.
dlchktime - Time interval for checking deadlock configuration parameter
This parameter defines the frequency at which the database manager checks for deadlocks among all the applications connected to a database.
enable_xmlchar - Enable conversion to XML configuration parameter
This parameter determines whether XMLPARSE operations can be performed on non-BIT DATA CHAR (or CHAR-type) expressions in an SQL statement.
encrlib - Encryption library configuration parameter
The encrlib configuration parameter enables automatic encryption of backups. The default value for the encrlib configuration parameter on a non-encrypted database is set to NULL, meaning that backups are not automatically encrypted. Use the encrlib parameter to specify the full absolute path to the encryption library which plugs in to the Db2 compression API, such as IBM® InfoSphere® Guardium® Data Encryption.
encropts - Encryption options configuration parameter
The default value for the encropts configuration parameter on a non-encrypt database is set to NULL. Use the encropt parameter in tandem with the encrlib parameter.
extbl_location - External table location configuration parameter
When a CREATE EXTERNAL TABLE statement is processed, and when the REMOTESOURCE option of the statement is set to LOCAL, the extbl_location parameter determines the path to the external table file.
extbl_strict_io - External table path type configuration parameter
When a CREATE EXTERNAL TABLE statement is processed, and when the REMOTESOURCE option of the statement is set to LOCAL, the extbl_strict_io parameter determines whether the path to the target directory is an absolute or relative path.
extended_row_sz - Extended row size configuration parameter
You can use the extended_row_sz configuration parameter to control if a table definition can exceed the maximum row length of a page.
failarchpath - Failover log archive path configuration parameter
This parameter specifies a path to which the Db2 database system will try to archive log files if the log files cannot be archived to either the primary or the secondary (if set) archive destinations because of a media problem affecting those destinations. This specified path must reference a disk.
groupheap_ratio - Percent of memory for application group heap 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.
hadr_db_role - HADR database role configuration parameter
This parameter indicates the current role of a database, whether the database is online or offline.
hadr_local_host - HADR local host name configuration parameter
This parameter specifies the local host for high availability disaster recovery (HADR) TCP communication.
hadr_local_svc - HADR local service name configuration parameter
This parameter specifies the TCP service name or port number for which the local high availability disaster recovery (HADR) process accepts connections.
hadr_peer_window - HADR peer window configuration parameter
When you set hadr_peer_window to a non-zero time value, then a HADR primary-standby database pair continues to behave as though still in peer state, for the configured amount of time, if the primary database loses connection with the standby database. This helps ensure data consistency.
hadr_remote_host - HADR remote host name configuration parameter
This parameter specifies the TCP/IP host name or IP address of the remote high availability disaster recovery (HADR) database server.
hadr_remote_inst - HADR instance name of the remote server configuration parameter
This parameter specifies the instance name of the remote server. High availability disaster recovery (HADR) also checks whether a remote database requesting a connection belongs to the declared remote instance.
hadr_remote_svc - HADR remote service name configuration parameter
This parameter specifies the TCP service name or port number that will be used by the remote high availability disaster recovery (HADR) database server.
hadr_replay_delay - HADR replay delay configuration parameter
This parameter specifies the number of seconds that must pass from the time that a transaction is committed on the primary database to the time that the transaction is committed on the standby database.
hadr_spool_limit - HADR log spool limit configuration parameter
The hadr_spool_limit parameter determines the maximum amount of log data that is allowed to be spooled to disk on HADR standby.
HADR_SSL_LABEL - Label name in the key file for encrypted communication between HADR primary and standby instances configuration parameter
This configuration parameter specifies the label of the Transport Layer Security (TLS) certificate that encrypts communication between primary and standby HADR instances in the key database.
hadr_syncmode - HADR synchronization mode for log writes in peer state configuration parameter
This parameter specifies the synchronization mode, which determines how log writes on the primary are synchronized with log writes on the standby when the systems are in peer state.
hadr_target_list - HADR target list database configuration parameter
This parameter specifies a list of target host:port pairs that represent HADR standby databases. You must set the hadr_target_list parameter to enable multiple standby databases or to set up HADR in a Db2 pureScale environment.
hadr_timeout - HADR timeout value configuration parameter
This parameter specifies the time (in seconds) that the high availability disaster recovery (HADR) process waits before considering a communication attempt to have failed.
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.
locklist - Maximum storage for lock list configuration parameter
This parameter indicates the amount of storage that is allocated to the lock list. There is one lock list per database and it contains the locks held by all applications concurrently connected to the database.
locktimeout - Lock timeout configuration parameter
This parameter specifies the number of seconds that an application will wait to obtain a lock, helping avoid global deadlocks for applications.
log_appl_info - Application information log record database configuration parameter
This parameter specifies that the application information log record is written at the start of each update transaction.
log_ddl_stmts - Log Data Definition Language (DDL) statements database configuration parameter
This parameter specifies that extra information regarding Data Definition Language (DDL) statements will be written to the log.
log_disk_cap - Active log space disk capacity configuration parameter
This parameter allows you to specify the maximum disk capacity for storing transaction log records in the active log path.
log_retain_status - Log retain status indicator configuration parameter
If the logarchmeth1 database configuration parameter is set to logretain then the log retain status parameter will show a value of RECOVERY, otherwise it will show a value of NO.
logarchcompr1 - Primary archived log file compression configuration parameter
This parameter specifies whether the log files written to the primary archive destination for logs are compressed.
logarchcompr2 - Secondary archived log file compression configuration parameter
This parameter specifies whether the log files written to the secondary archive destination for logs are compressed.
logarchmeth1 - Primary log archive method configuration parameter
You can use this parameter to specify the media type of the primary destination for logs that are archived from the current log path.
logarchmeth2 - Secondary log archive method configuration parameter
This parameter specifies the media type of the secondary destination for logs that are archived from either the current log path or the mirror log path.
logarchopt1 - Primary log archive options configuration parameter
This parameter specifies a string of options which control log archiving behavior when the primary archived log method, logarchmeth1, is enabled. Multiple options can be specified in the string and must be separated by white space.
logarchopt2 - Secondary log archive options configuration parameter
This parameter specifies a string of options which control log archiving behavior when the secondary archived log method ,logarchmeth2, is enabled. Multiple options can be specified in the string and must be separated by white space.
logbufsz - Log buffer size configuration parameter
This parameter allows you to specify the amount of the database heap (defined by the dbheap parameter) to use as a buffer for log records before writing these records to disk.
logfilsiz - Size of log files configuration parameter
This parameter defines the size of each primary and secondary log file. The size of these log files limits the number of log records that can be written to them before they become full and a new log file is required.
loghead - First active log file configuration parameter
This parameter contains the name of the log file that is currently active.
logindexbuild - Log index pages created configuration parameter
This parameter specifies whether index creation, recreation, or reorganization operations are logged so that indexes can be reconstructed during Db2 rollforward operations or high availability disaster recovery (HADR) log replay procedures.
logpath - Location of log files configuration parameter
This parameter contains the current path being used for logging purposes.
logprimary - Number of primary log files configuration parameter
This parameter allows you to specify the number of primary log files to be preallocated. The primary log files establish a fixed amount of storage allocated to the recovery log files.
logsecond - Number of secondary log files configuration parameter
This parameter specifies the number of secondary log files that are created and used for recovery log files. The secondary log files are created only as needed.
max_log - Maximum log per transaction configuration parameter
This parameter specifies if there is a limit to the percentage of the primary log space that a transaction can consume, and what that limit is.
maxappls - Maximum number of active applications configuration parameter
This parameter specifies the maximum number of concurrent applications that can be connected (both local and remote) to a database. Since each application that attaches to a database causes some private memory to be allocated, allowing a larger number of concurrent applications will potentially use more memory.
maxfilop - Maximum database files open per database
This parameter specifies the maximum number of file handles that can be open per database. Each active application is counted towards the value specified by maxfilop.
maxlocks - Maximum percent of lock list before escalation configuration parameter
This parameter defines a percentage of the lock list held by an application that must be filled before the database manager performs lock escalation.
min_dec_div_3 - Decimal division scale to 3 configuration parameter
Starting with Version 11.1.3.3, the min_dec_div_3 configuration parameter is ignored if the dec_arithmetic configuration parameter is set to a non-default value. Setting dec_arithmetic to "DEC.3" results in the same behavior as enabling the min_dec_div_3 configuration parameter.
mincommit - Number of commits to group configuration parameter
This parameter allows you to delay the writing of log records to disk until a minimum number of commits have been performed, helping to reduce the processing time the database manager requires when writing log records.
mirrorlogpath - Mirror log path configuration parameter
This parameter specifies a string of up to 242 bytes for the mirror log path. The string must point to a fully qualified path name.
mon_act_metrics - Monitoring activity metrics configuration parameter
This parameter controls the collection of activity metrics on the entire database and affects activities submitted by connections associated with any Db2 workload definitions.
mon_deadlock - Monitoring deadlock configuration parameter
This parameter controls the generation of deadlock events at the database level for the lock event monitor.
mon_locktimeout - Monitoring lock timeout configuration parameter
This parameter controls the generation of lock timeout events at the database level for the lock event monitor and affects all Db2 workload definitions.
mon_lockwait - Monitoring lock wait configuration parameter
This parameter controls the generation of lock wait events at the database level for the lock event monitor.
mon_lw_thresh - Monitoring lock wait threshold configuration parameter
This parameter controls the amount of time spent in lock wait before an event for mon_lockwait is generated.
mon_lck_msg_lvl - Monitoring lock event notification messages configuration parameter
This parameter controls the logging of messages to the administration notification log when lock timeout, deadlock, and lock escalation events occur.
mon_obj_metrics - Monitoring object metrics configuration parameter
This parameter controls the collection of data object metrics on an entire database.
mon_pkglist_sz - Monitoring package list size configuration parameter
This parameter controls the maximum number of entries that can appear in the package listing per unit of work as captured by the unit of work event monitor.
mon_req_metrics - Monitoring request metrics configuration parameter
This parameter controls the collection of request metrics on the entire database and affects requests executing in any Db2 service classes.
mon_rtn_data - Monitoring routine capture configuration parameter
The mon_rtn_data configuration parameter controls the capture of routine invocations. It is a parent parameter to the mon_rtn_execlist configuration parameter.
mon_rtn_execlist - Monitoring routine executable list configuration parameter
This parameter controls the monitoring of statements executed by routines. This is done at the database level and takes effect for any routine invocation within the database.
mon_uow_data - Monitoring unit of work events configuration parameter
This parameter specifies whether information about a unit of work, also referred to as a transaction, is sent to the active unit of work event monitors when the unit of work is completed. It is a parent parameter to the mon_uow_execlist and mon_uow_pkglist configuration parameters.
mon_uow_execlist - Monitoring unit of work events with executable list configuration parameter
This parameter controls the generation of unit of work events with executable ID listing information included. This is done at the database level for the unit of work event monitor. The mon_uow_execlist database configuration parameter is a child parameter of the mon_uow_data database configuration parameter.
mon_uow_pkglist - Monitoring unit of work events with package list configuration parameter
This parameter controls the generation of unit of work events with package listing information included.This is done at the database level for the unit of work event monitor. The mon_uow_pkglist database configuration parameter is a child parameter of the mon_uow_data database configuration parameter.
multipage_alloc - Multipage file allocation enabled configuration parameter
Multipage file allocation is used to allocate a full extent when growing SMS table spaces rather than a single page. It is used to improve insert performance, and it applies to SMS table spaces only. If enabled, all SMS table spaces are affected: there is no selection possible for individual SMS table spaces.
nchar_mapping - National character mapping configuration parameter
This parameter determines the data type mapping for national character string data types in MBCS databases.
newlogpath - Change the database log path configuration parameter
This parameter allows you to specify a string of up to 242 bytes to change the location where the log files are stored.
num_db_backups - Number of database backups configuration parameter
This parameter specifies the number of full database backups to retain for a database.
num_freqvalues - Number of frequent values retained configuration parameter
This parameter allows you to specify the number of most frequent values that will be collected when the WITH DISTRIBUTION option is specified on the RUNSTATS command.
num_iocleaners - Number of asynchronous page cleaners configuration parameter
This parameter allows you to specify the number of asynchronous page cleaners for a database.
num_ioservers - Number of I/O servers configuration parameter
This parameter specifies the number of I/O servers for a database. No more than this number of I/Os for prefetching and utilities can be in progress for a database at any time.
num_log_span - Number log span configuration parameter
This parameter specifies whether there is a limit to how many log files one transaction can span, and what that limit is.
num_quantiles - Number of quantiles for columns configuration parameter
This parameter controls the number of quantiles that will be collected when the WITH DISTRIBUTION option is specified on the RUNSTATS command.
numarchretry - Number of retries on error configuration parameter
This parameter specifies the number of attempts that Db2 must make to archive a log file to the primary or the secondary archive directory before trying to archive log files to the failover directory.
numsegs - Default number of SMS containers 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.
number_compat - Number compatibility database configuration parameter
This parameter indicates whether the compatibility semantics associated with the NUMBER data type are applied to the connected database.
opt_direct_wrkld - Optimize directed workload configuration parameter
This database configuration parameter enables or disables explicit hierarchical locking (EHL). It applies globally across all Db2 pureScale members.
overflowlogpath - Overflow log path configuration parameter
The overflowlogpath parameter specifies a location for Db2 databases to find log files needed for a rollforward operation, as well as where to store active log files retrieved from the archive. It also gives a location for finding and storing log files needed for using db2ReadLog API.
page_age_trgt_gcr - Page age target group crash recovery configuration parameter
This configuration parameter specifies the target duration (in seconds) for changed pages to be kept in the group buffer pool before the pages are persisted to table space storage. This parameter applies only to Db2 pureScale instances.
page_age_trgt_mcr - Page age target member crash recovery configuration parameter
This configuration parameter specifies the target duration (in seconds) for changed pages to be kept in the local buffer pool before they are persisted to table space storage, or for Db2 pureScale instances, to table space storage or to the group buffer pool.
pagesize - Database default page size
This parameter contains the value that was used as the default page size when the database was created. Possible values are: 4096, 8192, 16384 and 32768. When a buffer pool or table space is created in that database, the same default page size applies.
pckcachesz - Package cache size configuration parameter
This parameter is allocated out of the database shared memory, and is used for caching of sections for static and dynamic SQL and XQuery statements on a database.
pl_stack_trace - SQL PL and PL/SQL error stack logging configuration parameter
Starting in Db2 Version 10.5 Fix Pack 7, this parameter determines whether error stack logging is enabled or disabled for SQL PL and PL/SQL routines.
priv_mem_thresh - Private memory threshold 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.
rec_his_retentn - Recovery history retention period configuration parameter
This parameter specifies the number of days that historical information on backups are retained.
restore_pending - Restore pending configuration parameter
This parameter states whether a RESTORE PENDING status exists in the database.
restrict_access - Database has restricted access configuration parameter
This parameter indicates whether the database was created using the restrictive set of default actions. In other words, if it was created with the RESTRICTIVE clause in the CREATE DATABASE command.
rollfwd_pending - Roll forward pending indicator configuration parameter
This parameter informs you whether or not a rollforward recovery is required, and where it is required.
section_actuals - Section actuals configuration parameter
Section actuals are runtime statistics that are measured during section execution. This parameter enables collection of section actuals such that the statistics can be viewed when an event monitor is subsequently created.
self_tuning_mem- Self-tuning memory configuration parameter
This parameter determines whether the memory tuner will dynamically distribute available memory resources as required between memory consumers that are enabled for self-tuning.
seqdetect - Sequential detection and readahead flag configuration parameter
This parameter controls whether the database manager is allowed to perform sequential detection or readahead prefetching during I/O activity.
sheapthres_shr - Sort heap threshold for shared sorts configuration parameter
This parameter represents a soft limit on the total amount of shared sort memory reservation available to sort heap-based operations.
smtp_server - SMTP server database configuration parameter
This parameter identifies a simple mail transfer protocol (SMTP) server. This SMTP server transmits email sent by the UTL_MAIL built-in module.
softmax - Recovery range and soft checkpoint interval configuration parameter
This parameter determines the frequency of soft checkpoints and the recovery range, which help out in the crash recovery process.
sortheap - Sort heap size configuration parameter
This parameter defines the maximum number of private or shared memory pages that an operation that requires sort heap memory allocates.
sql_ccflags - Conditional compilation flags configuration parameter
This parameter contains a list of conditional compilation values for use in conditional compilation of selected SQL statements.
stat_heap_sz - Statistics heap size configuration parameter
This parameter indicates the maximum size of the heap used in collecting statistics using the RUNSTATS command.
stmt_conc - Statement concentrator configuration parameter
This configuration parameter sets the default statement concentrator behavior.
stmtheap - Statement heap size configuration parameter
This parameter specifies the limit of the statement heap, which is used as a work space for the SQL or XQuery compiler during compilation of an SQL or XQuery statement.
string_units - Default string units configuration parameter
This parameter specifies the default string units that are used when defining character data types and graphic data types in Unicode databases.
suspend_io - Database I/O operations state configuration parameter
This parameter shows whether the I/O write operations for a database are suspended or are being suspended.
systime_period_adj - Adjust temporal SYSTEM_TIME period database configuration parameter
This database configuration parameter specifies what action to take when a history row for a system-period temporal table is generated with an end timestamp that is less then the begin timestamp.
territory - Database territory configuration parameter
This parameter shows the territory used to create the database. territory is used by the database manager when processing data that is territory sensitive.
trackmod - Track modified pages enable configuration parameter
This parameter specifies whether the database manager will track database modifications so that the backup utility can detect which subsets of the database pages must be examined by an incremental backup and potentially included in the backup image.
tsm_mgmtclass - Tivoli Storage Manager management class configuration parameter
The Tivoli® Storage Manager management class determines how the TSM server manages the backup versions of the objects being backed up.
tsm_nodename - Tivoli Storage Manager node name configuration parameter
This parameter is used to override the default setting for the node name associated with the Tivoli Storage Manager (TSM) product.
tsm_owner - Tivoli Storage Manager owner name configuration parameter
This parameter is used to override the default setting for the owner associated with the Tivoli Storage Manager (TSM) product.
tsm_password - Tivoli Storage Manager password configuration parameter
This parameter is used to override the default setting for the password associated with the Tivoli Storage Manager (TSM) product.
user_exit_status - User exit status indicator configuration parameter
If set to YES, the user_exit_status parameter indicates that the database manager is enabled for rollforward recovery and that the database archives and retrieves log files based on the values set by either the logarchmeth1 parameter or the logarchmeth2 parameter.
util_heap_sz - Utility heap size configuration parameter
This parameter guides the amount of memory that is allocated by the database utilities.
varchar2_compat - varchar2 compatibility database configuration parameter
This parameter indicates whether the compatibility semantics associated with the VARCHAR2 and NVARCHAR2 data types are applied to the connected database.
vendoropt - Vendor options configuration parameter
This parameter specifies additional parameters that Db2 might need to use to communicate with storage systems during backup, restore, or load copy operations.
wlm_admission_ctrl - WLM admission control configuration parameter
This parameter specifies whether Db2 workload manager (WLM) admission control is enabled.
wlm_agent_load_trgt - WLM agent load target configuration parameter
This parameter specifies the target agent load, that is, the number of physical threads per CPU core.
wlm_collect_int - Workload management collection interval configuration parameter
This parameter specifies a collect and reset interval, in minutes, for workload management (WLM) statistics.
wlm_cpu_limit - WLM CPU limit configuration parameter
This parameter specifies the fixed amount of CPU that can be consumed by work that is running on a database.
wlm_cpu_shares - WLM CPU shares configuration parameter
This parameter specifies the number of shares of CPU resources allocated for work in a database.
wlm_cpu_share_mode - WLM CPU share mode configuration parameter
Db2 workload management can manage CPU resources by using shares-based entitlements that are assigned to a database. The number of CPU shares that are assigned can be specified by using the WLM_CPU_SHARES configuration parameter. This parameter specifies the type of share.

Parent topic: Configuration parameters