[DB2] 레지스트리 및 환경 변수

DB2® 데이터베이스 제품은 시작 및 실행을 위해 알아야 하는 여러 가지 레지스트리 변수 및 환경 변수를 제공합니다.

지원되는 모든 레지스트리 변수 목록을 보려면 다음 명령을 실행하십시오.

db2set -lr

db2start 명령을 실행하기 전에 갱신할 레지스트리 변수에 대한 값을 설정해야 합니다.

다음 표에는 범주별 모든 레지스트리 변수가 나열되어 있습니다.

표 1. 레지스트리 및 환경 변수 요약변수 범주레지스트리 또는 환경 변수 이름

일반

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_OBJECT_TABLE_ENTRIES
DB2_SYSTEM_MONITOR_SETTINGS
DB2TERRITORY
DB2_VIEW_REOPT_VALUES

시스템 환경

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

통신

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

명령행

DB2BQTIME
DB2BQTRY
DB2_CLP_EDITOR
DB2_CLP_HISTSIZE
DB2_CLPPROMPT
DB2IQTIME
DB2RQTIME

파티션된 데이터베이스 환경

DB2CHGPWD_EEE
DB2_FCM_SETTINGS
DB2_FORCE_OFFLINE_ADD_PARTITION
DB2_NUM_FAILOVER_NODES
DB2_PARTITIONEDLOAD_DEFAULT
DB2PORTRANGE

쿼리 컴파일러

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

성능

DB2_ALLOCATION_SIZE
DB2_APM_PERFORMANCE
DB2ASSUMEUPDATE
DB2_ASYNC_IO_MAXFILOP
DB2_AVOID_PREFETCH
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_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

기타

DB2ADMINSERVER
DB2_ATS_ENABLE
DB2AUTH
DB2CLIINIPATH
DB2_COMMIT_ON_EXIT
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
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
DB2ROUTINE_DEBUG
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

Designed by JB FACTORY