Db2 registry and environment variables

Db2 database products provide a number of registry variables and environment variables that you might need to know about to get up and running.

To view a list of all supported registry variables, execute the following command:

db2set -lr

You must set values for registry variables that you want to update before you execute the db2start command.

The following table lists all registry variables by category.

Table 1. Registry and environment variables summary
Variable category	Registry or environment variable name
General	DB2ACCOUNT DB2BIDI DB2_BYPASS_DEFAULT_ISOLATION_APPS DB2_BYPASS_DEFAULT_ISOLATION_GROUPS DB2_BYPASS_DEFAULT_ISOLATION_USERS DB2_CAPTURE_LOCKTIMEOUT DB2CODEPAGE DB2_COLLECT_TS_REC_INFO DB2_CONNRETRIES_INTERVAL DB2CONSOLECP DB2DBDFT DB2_DEFAULT_ISOLATION_VALUE DB2DISCOVERYTIME DB2_ENFORCE_MEMBER_SYNTAX DB2FODC DB2_FORCE_APP_ON_MAX_LOG	DB2GRAPHICUNICODESERVER DB2INCLUDE DB2INSTDEF DB2INSTOWNER DB2_LIC_STAT_SIZE DB2LOCALE DB2_MAX_CLIENT_CONNRETRIES DB2_MAX_GLOBAL_SNAPSHOT_SIZE DB2_OBJECT_TABLE_ENTRIES DB2_SRVLSTLOG_LEVEL DB2_SYSTEM_MONITOR_SETTINGS DB2TERRITORY DB2_VIEW_REOPT_VALUES DB2_ONLINERECOVERY DB2_ONLINERECOVERY_WITH_UR_ACCESS
System environment	DB2_ALTERNATE_GROUP_LOOKUP DB2_CLI_DRIVER_INSTALL_PATH DB2CONNECT_ENABLE_EURO_CODEPAGE DB2CONNECT_IN_APP_PROCESS DB2_COPY_NAME DB2_CPU_BINDING DB2DBMSADDR DB2_DIAGPATH DB2DOMAINLIST DB2ENVLIST DB2INSTANCE DB2INSTPROF DB2LDAPSecurityConfig DB2LIBPATH DB2LOGINRESTRICTIONS	DB2NODE DB2OPTIONS DB2_PARALLEL_IO DB2PATH DB2_PMAP_COMPATIBILITY DB2PROCESSORS DB2RCMD_LEGACY_MODE DB2RESILIENCE DB2_RESTORE_GRANT_ADMIN_AUTHORITIES DB2_SKIP_CHK_TMP DB2_SYMPHONY_WLM DB2SYSTEM DB2TMPDIR DB2_UPDDBCFG_SINGLE_DBPARTITION DB2_USE_PAGE_CONTAINER_TAG DB2WORKDIR DB2_WORKLOAD
Communications	DB2_ALLOW_WLB_WITH_SEQUENCES DB2CHECKCLIENTINTERVAL DB2COMM DB2FCMCOMM DB2_FORCE_NLS_CACHE DB2_PMODEL_SETTINGS DB2RSHCMD DB2RSHTIMEOUT	DB2SORCVBUF DB2SOSNDBUF DB2TCP_CLIENT_CONTIMEOUT DB2TCP_CLIENT_KEEPALIVE_TIMEOUT DB2TCP_CLIENT_RCVTIMEOUT DB2TCPCONNMGRS DB2TCP_SERVER_KEEPALIVE_TIMEOUT
Command-line	DB2BQTIME DB2BQTRY DB2_CLP_EDITOR DB2_CLP_HISTSIZE	DB2_CLPPROMPT DB2IQTIME DB2RQTIME
Partitioned database environment	DB2CHGPWD_EEE DB2_FCM_SETTINGS DB2_FORCE_OFFLINE_ADD_PARTITION	DB2_NUM_FAILOVER_NODES DB2_PARTITIONEDLOAD_DEFAULT DB2PORTRANGE
Db2 pureScale® environment	DB2_DATABASE_CF_MEMORY DB2_SD_ALLOW_SLOW_NETWORK	DB2_MCR_RECOVERY_PARALLELISM_CAP
Query compiler	DB2_ANTIJOIN DB2_DEFERRED_PREPARE_SEMANTICS DB2_INLIST_TO_NLJN DB2_LIKE_VARCHAR DB2_MINIMIZE_LISTPREFETCH	DB2_NEW_CORR_SQ_FF DB2_OPT_MAX_TEMP_SIZE DB2_REDUCED_OPTIMIZATION DB2_SELECTIVITY DB2_SQLROUTINE_PREPOPTS
Performance	DB2_ALLOCATION_SIZE DB2_APM_PERFORMANCE DB2ASSUMEUPDATE DB2_AVOID_PREFETCH DB2_BACKUP_USE_DIO DB2BPVARS DB2CHKPTR DB2CHKSQLDA DB2_EVALUNCOMMITTED DB2_EXTEND_COL_UNIQUE_INDEX_ACCESS DB2_EXTENDED_IO_FEATURES DB2_EXTENDED_OPTIMIZATION DB2_INDEX_CREATE_ALLOW_WRITE DB2_IO_PRIORITY_SETTING DB2_KEEP_AS_AND_DMS_CONTAINERS_OPEN DB2_KEEPTABLELOCK DB2_LARGE_PAGE_MEM DB2_LOGGER_NON_BUFFERED_IO DB2MAXFSCRSEARCH DB2_MAX_INACT_STMTS DB2_MAX_NON_TABLE_LOCKS DB2_MDC_ROLLOUT DB2MEMDISCLAIM DB2_MEM_TUNING_RANGE DB2_MMAP_READ	DB2_MMAP_WRITE DB2_NO_FORK_CHECK DB2NTMEMSIZE DB2NTNOCACHE DB2NTPRICLASS DB2NTWORKSET DB2_OVERRIDE_BPF DB2_PINNED_BP DB2PRIORITIES DB2_RCT_FEATURES DB2_REDUCE_FLUSHING_DURING_BACKUP DB2_RESOURCE_POLICY DB2_SELUDI_COMM_BUFFER DB2_SET_MAX_CONTAINER_SIZE DB2_SKIPDELETED DB2_SKIPINSERTED DB2_SMP_INDEX_CREATE DB2_SMS_TRUNC_TMPTABLE_THRESH DB2_SORT_AFTER_TQ DB2_SQLWORKSPACE_CACHE DB2_USE_ALTERNATE_PAGE_CLEANING DB2_USE_ASYNC_FOR_MIRRORLOG DB2_USE_BUFFERED_READ_FOR_ACTIVE_LOG DB2_USE_FAST_PREALLOCATION DB2_USE_FAST_LOG_PREALLOCATION DB2_USE_IOCP DB2_4K_DEVICE_SUPPORT
Miscellaneous	DB2ADMINSERVER DB2_ATS_ENABLE DB2AUTH DB2_BCKP_INCLUDE_LOGS_WARNING DB2_BCKP_PAGE_VERIFICATION DB2CLIINIPATH DB2_COMMIT_ON_EXIT DB2_COMMON_APP_DATA_PATH DB2_COMPATIBILITY_VECTOR DB2_CREATE_DB_ON_PATH DB2_DDL_SOFT_INVAL DB2_DISABLE_FLUSH_LOG DB2_DISPATCHER_PEEKTIMEOUT DB2_DJ_INI DB2_DMU_DEFAULT DB2_DOCHOST DB2_DOCPORT DB2DSDRIVER_CFG_PATH DB2DSDRIVER_CLIENT_HOSTNAME DB2_ENABLE_AUTOCONFIG_DEFAULT DB2_ENABLE_LDAP DB2_EVMON_EVENT_LIST_SIZE DB2_EVMON_STMT_FILTER DB2_EXTSECURITY DB2_FALLBACK DB2_FMP_COMM_HEAPSZ DB2_GRP_LOOKUP DB2_HADR_BUF_SIZE DB2_HADR_NO_IP_CHECK DB2_HADR_PEER_WAIT_LIMIT DB2_HADR_REPLAY_ONLY_WINDOW_DIAGLEVEL DB2_HADR_ROS DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW DB2_HADR_SORCVBUF DB2_HADR_SOSNDBUF	DB2_HISTORY_FILTER DB2_INDEX_PCTFREE_DEFAULT DB2LDAP_BASEDN DB2LDAPCACHE DB2LDAP_CLIENT_PROVIDER DB2LDAPHOST DB2LDAP_KEEP_CONNECTION DB2LDAP_SEARCH_SCOPE DB2_LOAD_COPY_NO_OVERRIDE DB2_LIMIT_FENCED_GROUP DB2LOADREC DB2LOCK_TO_RB DB2_MAX_LOB_BLOCK_SIZE DB2_MEMORY_PROTECT DB2_MIN_IDLE_RESOURCES DB2_NCHAR_SUPPORT DB2NOEXITLIST DB2_NUM_CKPW_DAEMONS DB2_OPTSTATS_LOG DB2REMOTEPREG DB2_RESOLVE_CALL_CONFLICT DB2_RESTRICT_DDF DB2_SAS_SETTINGS DB2SATELLITEID DB2_SERVER_CONTIMEOUT DB2_SERVER_ENCALG DB2SORT DB2_STANDBY_ISO DB2STMM DB2_SYNC_RELEASE_LOCK_ATTRIBUTES DB2_TRUNCATE_REUSESTORAGE DB2_UTIL_MSGPATH DB2_XBSA_LIBRARY DB2_XSLT_ALLOWED_PATH