Supported DB2 LUW System Configuration Parameters

Go Up to Parameters, Arguments, Options, and Variables Appendix

The following parameters are available from the Explorer’s Database Configuration node. For information on working with these parameters, see Working with Configuration/initialization Parameters.

app_ctl_heap_sz	appgroup_mem_sz	applheapsz
archretrydelay	auto_maint	auto_db_backup
auto_tbl_maint	auto_runstats	auto_stmt_stats
auto_stats_prof	auto_prof_upd	auto_reorg
autorestart	avg_appls	blk_log_dsk_fu
catalogcache_sz	chngpgs_thresh	database_memory
dbheap	dft_degree	dft_extent_sz
dft_loadrec_ses	dft_mttb_types	dft_prefetch_sz
dft_queryopt	dft_refresh_age	dft_sqlmathwarn
discover_db	dlchktime	dyn_query_mgmt
failarchpath	groupheap_ratio	hadr_local_host
hadr_local_svc	hadr_remote_host	hadr_remote_inst
hadr_remote_svc	hadr_syncmode	hadr_timeout
hadr_peer_window	indexrec Index	locklist Maximum storage
locktimeout Lock timeout	logarchmeth1	logarchmeth2
logarchopt1	logarchopt2	logbufsz
logfilsiz	logindexbuild	logprimary
logretain	logsecond	max_log
maxappls	maxfilop	maxlocks
min_dec_div_3	mincommit	mirrorlogpath
newlogpath	num_db_backups	num_freqvalues
num_iocleaners	num_ioservers	num_log_span
num_quantiles	numarchretry	overflowlogpath
pckcachesz	rec_his_retentn	self_tuning_mem
seqdetect	sheapthres_shr	softmax
sortheap	stat_heap_sz	stmtheap
trackmod	tsm_mgmtclass	tsm_nodename
tsm_owner	tsm_password	userexit
util_heap_sz	vendoropt	backup_pending
codepage	codeset	collate_info
country	database_consistent	database_level
hadr_db_role	log_retain_status	loghead
logpath	multipage_alloc	numsegs
pagesize	release	restore_pending
rollfwd_pending	territory Database	user_exit_status
db_mem_thresh	db_collname	enable_xmlchar
restrict_access	appl_memory	wlm_collect_int
decflt_rounding