DB2 Version 9.7 for Linux, UNIX, and Windows

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_CAPTURE_LOCKTIMEOUT DB2CODEPAGE DB2_COLLECT_TS_REC_INFO DB2_CONNRETRIES_INTERVAL DB2CONSOLECP DB2COUNTRY DB2DBDFT DB2DISCOVERYTIME DB2FFDC 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_SYSTEM_MONITOR_SETTINGS DB2TERRITORY DB2_VIEW_REOPT_VALUES
System environment	DB2_ALTERNATE_GROUP_LOOKUP DB2CONNECT_ENABLE_EURO_CODEPAGE DB2CONNECT_IN_APP_PROCESS DB2_COPY_NAME 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 DB2SYSTEM DB2_UPDDBCFG_SINGLE_DBPARTITION DB2_USE_PAGE_CONTAINER_TAG DB2_WORKLOAD
Communications	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
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
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_ASYNC_IO_MAXFILOP DB2_AVOID_PREFETCH DB2_BACKUP_USE_DIO DB2BPVARS DB2CHKPTR DB2CHKSQLDA DB2_EVALUNCOMMITTED DB2_EXTENDED_IO_FEATURES DB2_EXTENDED_OPTIMIZATION DB2_HASH_JOIN 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 DB2MEMMAXFREE DB2_MEM_TUNING_RANGE	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_RESOURCE_POLICY DB2_SET_MAX_CONTAINER_SIZE DB2_SKIPDELETED DB2_SKIPINSERTED DB2_SMS_TRUNC_TMPTABLE_THRESH DB2_SORT_AFTER_TQ DB2_SQLWORKSPACE_CACHE DB2_SELUDI_COMM_BUFFER DB2_TRUSTED_BINDIN DB2_USE_ALTERNATE_PAGE_CLEANING DB2_USE_FAST_PREALLOCATION DB2_USE_IOCP
Miscellaneous	DB2ADMINSERVER DB2_ATS_ENABLE DB2AUTH DB2CLIINIPATH DB2_COMMIT_ON_EXIT DB2_COMMON_APP_DATA_PATH DB2_COMPATIBILITY_VECTOR DB2_CREATE_DB_ON_PATH DB2_DDL_SOFT_INVAL DB2DEFPREP DB2_DISABLE_FLUSH_LOG DB2_DISPATCHER_PEEKTIMEOUT DB2_DJ_INI DB2DMNBCKCTLR DB2_DOCHOST DB2_DOCPORT DB2DSDRIVER_CFG_PATH 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_ROS DB2_HADR_SORCVBUF DB2_HADR_SOSNDBUF DB2_HISTORY_FILTER 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_MAP_XML_AS_CLOB_FOR_DLC DB2_MAX_LOB_BLOCK_SIZE DB2_MEMORY_PROTECT DB2_MIN_IDLE_RESOURCES DB2NOEXITLIST DB2_NCHAR_SUPPORT DB2_NUM_CKPW_DAEMONS DB2_OPTSTATS_LOG DB2REMOTEPREG DB2_RESOLVE_CALL_CONFLICT DB2_RESTRICT_DDF DB2ROUTINE_DEBUG DB2_SAS_SETTINGS DB2SATELLITEID DB2_SERVER_CONTIMEOUT DB2_SERVER_ENCALG DB2SORT DB2_STANDBY_ISO DB2STMM DB2_TRUNCATE_REUSESTORAGE DB2_USE_DB2JCCT2_JROUTINE DB2_UTIL_MSGPATH DB2_VENDOR_INI DB2_XBSA_LIBRARY