db2set常用命令
db2set -lr 用于列出所有支持的注册表变量
DB2_OVERRIDE_BPF
DB2_PARALLEL_IO
DB2ACCOUNT
DB2ADMINSERVER
DB2BQTIME
DB2BQTRY
DB2CHKPTR
DB2CLIINIPATH
DB2CODEPAGE
DB2COMM
DB2COUNTRY
DB2DBDFT
DB2DBMSADDR
DB2DEFPREP
DB2DMNBCKCTLR
DB2INCLUDE
DB2INSTDEF
DB2INSTPROF
DB2IQTIME
DB2LOADREC
DB2LOCK_TO_RB
DB2NTNOCACHE
DB2NTPRICLASS
DB2NTWORKSET
DB2OPTIONS
DB2PATH
DB2PRIORITIES
DB2REMOTEPREG
DB2RQTIME
DB2SORCVBUF
DB2SORT
DB2SOSNDBUF
DB2SYSTEM
DB2_FORCE_NLS_CACHE
DB2YIELD
DB2_AVOID_PREFETCH
DB2_COLLECT_TS_REC_INFO
DB2_GRP_LOOKUP
DB2_INDEX_FREE
DB2_MMAP_READ
DB2_MMAP_WRITE
DB2DISCOVERYTIME
DB2ENVLIST
DB2MEMDISCLAIM
DB2LIBPATH
DB2CHKSQLDA
DB2PORTRANGE
DB2INSTOWNER
DB2NOEXITLIST
DB2LOADFLAGS
DB2_HASH_JOIN
DB2NTMEMSIZE
DB2CHECKCLIENTINTERVAL
DB2_FALLBACK
DB2PROCESSORS
DB2ATLD_PORTS
DB2_SORT_AFTER_TQ
DB2_LIKE_VARCHAR
DB2ASSUMEUPDATE
DB2MAXFSCRSEARCH
DB2BIDI
DB2_NEW_CORR_SQ_FF
DB2CHGPWD_EEE
DB2LOCALE
DB2_SKIPDELETED
DB2LDAPHOST
DB2LDAPCACHE
DB2LDAP_CLIENT_PROVIDER
DB2LDAP_BASEDN
DB2_ENABLE_LDAP
DB2_SYSTEM_MONITOR_SETTINGS
DB2SATELLITEID
DB2_LIC_STAT_SIZE
DB2CONNECT_IN_APP_PROCESS
DB2_NUM_FAILOVER_NODES
DB2ROUTINE_DEBUG
DB2_DJ_INI
DB2_DJ_COMM
DB2TCPCONNMGRS
DB2_SQLROUTINE_PREPOPTS
DB2_ANTIJOIN
DB2_DISABLE_FLUSH_LOG
DB2_SELECTIVITY
DB2_EXTENDED_OPTIMIZATION
DB2_ENABLE_SINGLE_NIS_GROUP
DB2_PINNED_BP
DB2_APM_PERFORMANCE
DB2_XBSA_LIBRARY
DB2_VENDOR_INI
DB2DOMAINLIST
DB2_FMP_COMM_HEAPSZ
DB2_SNAPSHOT_NOAUTH
DB2_EVALUNCOMMITTED
DB2TERRITORY
DB2_PARTITIONEDLOAD_DEFAULT
DB2_ALLOCATION_SIZE
DB2_NO_FORK_CHECK
DB2_REDUCED_OPTIMIZATION
DB2CONSOLECP
DB2_USE_PAGE_CONTAINER_TAG
DB2HTSTACKOPTIMIZATION
DB2_NUM_CKPW_DAEMONS
DB2_KEEPTABLELOCK
DB2GRAPHICUNICODESERVER
DB2_MINIMIZE_LISTPREFETCH
DB2_INLIST_TO_NLJN
DB2_MEM_TUNING_RANGE
DB2_TRUSTED_BINDIN
DB2_CLPPROMPT
DB2_FORCE_APP_ON_MAX_LOG
DB2_CLP_EDITOR
DB2_CLP_HISTSIZE
DB2_LOAD_COPY_NO_OVERRIDE
DB2_USE_DB2JCCT2_JROUTINE
DB2_MAX_NON_TABLE_LOCKS
DB2_SMS_TRUNC_TMPTABLE_THRESH
DB2_USE_ALTERNATE_PAGE_CLEANING
DB2_HADR_BUF_SIZE
DB2_MAX_CLIENT_CONNRETRIES
DB2_CONNRETRIES_INTERVAL
DB2_DOCHOST
DB2_DOCPORT
DB2_TAPEMGR_TAPE_EXPIRATION
DB2_EXTSECURITY
DB2_OBJECT_TABLE_ENTRIES
DB2RCMD_LEGACY_MODE
DB2_LOGGING_DETAIL
DB2_VIEW_REOPT_VALUES
DB2_SELUDI_COMM_BUFFER
DB2_RESOURCE_POLICY
DB2TCP_CLIENT_RCVTIMEOUT
DB2_SKIPINSERTED
DB2CONNECT_DISCONNECT_ON_INTERRUPT
DB2_LARGE_PAGE_MEM
DB2_ALTERNATE_GROUP_LOOKUP
DB2AUTH
DB2FFDC
DB2FODC
DB2_ASYNC_IO_MAXFILOP
DB2RSHCMD
DB2RSHTIMEOUT
DB2_MDC_ROLLOUT
DB2_TRUNCATE_REUSESTORAGE
DB2_WORKLOAD
DB2_DXX_PATHS_ALLOWED_READ
DB2_DXX_PATHS_ALLOWED_WRITE
DB2TCP_CLIENT_CONTIMEOUT
DB2_MAX_INACT_STMTS
DB2FCMCOMM
DB2_EXTENDED_IO_FEATURES
DB2_UTIL_MSGPATH
DB2_ENABLE_AUTOCONFIG_DEFAULT
DB2_MAP_XML_AS_CLOB_FOR_DLC
DB2_OPT_MAX_TEMP_SIZE
DB2_MAX_LOB_BLOCK_SIZE
DB2_MINIMUM_CLIENT_LEVEL
DB2CONNECT_ENABLE_EURO_CODEPAGE
DB2TRC_DEF_BUFFSIZE
DB2_RESOLVE_CALL_CONFLICT
DB2_IO_PRIORITY_SETTING
DB2_EVMON_STMT_FILTER
DB2_SERVER_CONTIMEOUT
DB2_DISPATCHER_PEEKTIMEOUT
DB2_CREATE_DB_ON_PATH
DB2_EVMON_EVENT_LIST_SIZE
DB2_MEMORY_PROTECT
DB2_SET_MAX_CONTAINER_SIZE
DB2_UPDDBCFG_SINGLE_DBPARTITION
DB2_LIMIT_FENCED_GROUP
DB2_CAPTURE_LOCKTIMEOUT
DB2_HADR_NO_IP_CHECK
DB2_OPTSTATS_LOG
DB2_ATS_ENABLE
DB2_ALLOW_PUREXML_IN_DPF
关于注册表变量（db2set -all）显示后，-i ，-g 等存放的响应的文件的说明
The DB2 profile registry consists of the following registries:
• The DB2 Instance-Level Profile Registry: Variables set at this level apply only to a
specific instance.
• The DB2 Global-Level Profile Registry: Variables set at this level apply globally to all
instances.
• The DB2 Instance Node-Level Profile Registry: Variables at this level apply to a
specific partition in a multipartitioned DB2 environment.
• The DB2 Instance Profile Registry: This contains a list of all instances in the system. The
command db2ilist, which lists all instances in a system, uses this registry as input.
The DB2 registries are stored as binary or text files in different locations depending on the operating system.
default.env (db2set -g) --- global instance profile registry --- /opt/IBM/db2/V9.5
profile.env (db2set -i) --- local instance profile registry ---$HOME/sqllib
node_num.env - DB2 instance node level profile registry --$HOME/sqllib/nodes
profiles.reg - DB2 software version profile registry ---/opt/IBM/db2/V9.5
• The DB2 Instance-Level Profile Registry: Variables set at this level apply only to a
specific instance.
• The DB2 Global-Level Profile Registry: Variables set at this level apply globally to all
instances.
• The DB2 Instance Node-Level Profile Registry: Variables at this level apply to a
specific partition in a multipartitioned DB2 environment.
• The DB2 Instance Profile Registry: This contains a list of all instances in the system. The
command db2ilist, which lists all instances in a system, uses this registry as input.
The DB2 registries are stored as binary or text files in different locations depending on the operating system.
default.env (db2set -g) --- global instance profile registry --- /opt/IBM/db2/V9.5
profile.env (db2set -i) --- local instance profile registry ---$HOME/sqllib
node_num.env - DB2 instance node level profile registry --$HOME/sqllib/nodes
profiles.reg - DB2 software version profile registry ---/opt/IBM/db2/V9.5
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0Ctrl+Enter 发表
添加新评论0 条评论