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 |