UJP - DB2 Express-C database server for Windows (64bit) その11 db2set -allで設定情報の表示

I hope this helps.

不正IP報告数

Okan Sensor
 
メイン
ログイン
ブログ カテゴリ一覧

ブログ - DB2 Express-C database server for Windows (64bit) その11 db2set -allで設定情報の表示

DB2 Express-C database server for Windows (64bit) その11 db2set -allで設定情報の表示

カテゴリ : 
コンピュータ » サーバソフト » Db2
ブロガー : 
ujpblog 2019/1/27 19:41
 db2setコマンドを使って,プロファイル変数の表示を行う.
C:\Program Files\IBM\SQLLIB\BIN>db2set -all🆑
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2COPY1
[i] DB2COMM=TCPIP
[g] DB2_COMPATIBILITY_VECTOR=MYS
[g] DB2_EXTSECURITY=NO
[g] DB2_COMMON_APP_DATA_PATH=C:\ProgramData
[g] DB2SYSTEM=WINDOWS81PRO
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00

C:\Program Files\IBM\SQLLIB\BIN>

 先頭の3文字は,次のような意味.

・環境は、[e] で示されます。
・ユーザー・レベル・レジストリーは、[u]
・ノード・レベル・レジストリーは、[n]
・インスタンス・レベル・レジストリーは、[i]
・グローバル・レベル・レジストリーは、[g]

db2set -lrで, サポートされたすべてのレジストリー変数をリストする.
C:\Program Files\IBM\SQLLIB\BIN>db2set -lr🆑
DB2_OVERRIDE_BPF
DB2_PARALLEL_IO
DB2ACCOUNT
DB2ADMINSERVER
DB2BQTIME
DB2BQTRY
DB2CHKPTR
DB2CLIINIPATH
DB2CODEPAGE
DB2COMM
DB2DBDFT
DB2DBMSADDR
DB2INCLUDE
DB2INSTDEF
DB2INSTPROF
DB2IQTIME
DB2LOADREC
DB2LOCK_TO_RB
DB2NTNOCACHE
DB2NTPRICLASS
DB2NTWORKSET
DB2OPTIONS
DB2PATH
DB2PRIORITIES
DB2REMOTEPREG
DB2RQTIME
DB2SORCVBUF
DB2SORT
DB2SOSNDBUF
DB2SYSTEM
DB2_FORCE_NLS_CACHE
DB2_AVOID_PREFETCH
DB2_COLLECT_TS_REC_INFO
DB2_GRP_LOOKUP
DB2DISCOVERYTIME
DB2ENVLIST
DB2MEMDISCLAIM
DB2LIBPATH
DB2CHKSQLDA
DB2PORTRANGE
DB2INSTOWNER
DB2NOEXITLIST
DB2LOADFLAGS
DB2NTMEMSIZE
DB2CHECKCLIENTINTERVAL
DB2_FALLBACK
DB2PROCESSORS
DB2_SORT_AFTER_TQ
DB2ASSUMEUPDATE
DB2MAXFSCRSEARCH
DB2BIDI
DB2_NEW_CORR_SQ_FF
DB2CHGPWD_EEE
DB2LOCALE
DB2_SKIPDELETED
DB2_SMP_INDEX_CREATE
DB2LDAPHOST
DB2LDAPCACHE
DB2LDAP_BASEDN
DB2_ENABLE_LDAP
DB2_SYSTEM_MONITOR_SETTINGS
DB2_FCM_SETTINGS
DB2SATELLITEID
DB2_LIC_STAT_SIZE
DB2CONNECT_IN_APP_PROCESS
DB2_NUM_FAILOVER_NODES
DB2_DJ_INI
DB2TCPCONNMGRS
DB2_SQLROUTINE_PREPOPTS
DB2_ANTIJOIN
DB2_DISABLE_FLUSH_LOG
DB2_SELECTIVITY
DB2_EXTENDED_OPTIMIZATION
DB2_PINNED_BP
DB2_APM_PERFORMANCE
DB2_XBSA_LIBRARY
DB2_VENDOR_INI
DB2DOMAINLIST
DB2_FMP_COMM_HEAPSZ
DB2_LOGGER_NON_BUFFERED_IO
DB2_EVALUNCOMMITTED
DB2TERRITORY
DB2_PARTITIONEDLOAD_DEFAULT
DB2_REDUCED_OPTIMIZATION
DB2CONSOLECP
DB2_USE_PAGE_CONTAINER_TAG
DB2HTSTACKOPTIMIZATION
DB2_NUM_CKPW_DAEMONS
DB2_KEEPTABLELOCK
DB2_COMMON_APP_DATA_PATH
DB2GRAPHICUNICODESERVER
DB2_MINIMIZE_LISTPREFETCH
DB2_INLIST_TO_NLJN
DB2STMM
DB2_MEM_TUNING_RANGE
DB2_CLPPROMPT
DB2_FORCE_APP_ON_MAX_LOG
DB2_BCKP_INCLUDE_LOGS_WARNING
DB2_BCKP_PAGE_VERIFICATION
DB2_CLP_EDITOR
DB2_CLP_HISTSIZE
DB2_LOAD_COPY_NO_OVERRIDE
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_DDL_SOFT_INVAL
DB2_SKIPINSERTED
DB2CONNECT_DISCONNECT_ON_INTERRUPT
DB2_LARGE_PAGE_MEM
DB2_HISTORY_FILTER
DB2_ALTERNATE_GROUP_LOOKUP
DB2AUTH
DB2FODC
DB2RSHCMD
DB2RSHTIMEOUT
DB2_DMU_DEFAULT
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
DB2_USE_FAST_PREALLOCATION
DB2FCMCOMM
DB2_EXTENDED_IO_FEATURES
DB2_UTIL_MSGPATH
DB2_ENABLE_AUTOCONFIG_DEFAULT
DB2_OPT_MAX_TEMP_SIZE
DB2_MAX_LOB_BLOCK_SIZE
DB2_MINIMUM_CLIENT_LEVEL
DB2CONNECT_ENABLE_EURO_CODEPAGE
DB2_RESOLVE_CALL_CONFLICT
DB2_IO_PRIORITY_SETTING
DB2_EVMON_STMT_FILTER
DB2_SERVER_CONTIMEOUT
DB2_DISPATCHER_PEEKTIMEOUT
DB2_CREATE_DB_ON_PATH
DB2_CONNECT_GWY_AUTH_SUPP
DB2_EVMON_EVENT_LIST_SIZE
DB2_MEMORY_PROTECT
DB2_SET_MAX_CONTAINER_SIZE
DB2_UPDDBCFG_SINGLE_DBPARTITION
DB2_LIMIT_FENCED_GROUP
DB2_MAX_GLOBAL_SNAPSHOT_SIZE
DB2_COMPATIBILITY_VECTOR
DB2_CAPTURE_LOCKTIMEOUT
DB2_HADR_NO_IP_CHECK
DB2_HADR_PEER_WAIT_LIMIT
DB2_OPTSTATS_LOG
DB2_ATS_ENABLE
DB2_PMODEL_SETTINGS
DB2_KEEP_AS_AND_DMS_CONTAINERS_OPEN
DB2RESILIENCE
DB2_FORCE_OFFLINE_ADD_PARTITION
DB2_HADR_SOSNDBUF
DB2_HADR_SORCVBUF
DB2_DEFERRED_PREPARE_SEMANTICS
DB2TCP_CLIENT_KEEPALIVE_TIMEOUT
DB2_PMAP_COMPATIBILITY
DB2_HADR_ROS
DB2_STANDBY_ISO
DB2_BACKUP_USE_DIO
DB2_NCHAR_SUPPORT
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES
DB2_ENFORCE_MEMBER_SYNTAX
DB2_MEMBER_LOAD_WEIGHT_COMPOSITION
DB2_CF_API_SAMPLING_COUNT
DB2_CF_API_SAMPLING_INTERVAL
DB2_CF_API_SPIN_YIELD_THRESHOLD
DB2_CPU_BINDING
DB2_AVOID_SECONDARY_DELETE
DB2_SAL_FAILOVER_REGISTERPAGES_INSTEADOF_INVALIDATE_ALL
DB2_DATABASE_CF_MEMORY
DB2_MCR_RECOVERY_PARALLELISM_CAP
DB2_CONFIG_OS_ENV
DB2_SQLWORKSPACE_CACHE
DB2TCP_SERVER_KEEPALIVE_TIMEOUT
DB2_INDEX_PCTFREE_DEFAULT
DB2_ALLOW_WLB_WITH_SEQUENCES
DB2_XSLT_ALLOWED_PATH
DB2LDAP_UID
DB2LDAP_PWD
DB2_USE_FAST_LOG_PREALLOCATION
DB2_SD_ALLOW_SLOW_NETWORK
DB2_TRANSCHEMA_EXCLUDE_STATS
DB2_EXT_TABLE_SETTINGS
DB2_SYMPHONY_WLM
DB2_FMP_FODC
DB2_BIGSQL_LIBPATH
DB2_BCKP_COMPRESSION
DB2_DEFAULT_TABLE_DISTRIBUTION
DB2_EM_PAGE_VERIFICATION
DB2_DEK_MAC_TYPE
DB2_ONLINERECOVERY_WITH_UR_ACCESS
DB2_ONLINERECOVERY
DB2_AVOID_LOCK_ESCALATION
DB2_EXTEND_COL_UNIQUE_INDEX_ACCESS
DB2_USE_BUFFERED_READ_FOR_ACTIVE_LOG
DB2_SYNC_RELEASE_LOCK_ATTRIBUTES
DB2_HADR_REPLAY_ONLY_WINDOW_DIAGLEVEL
DB2_ENABLE_PS_EXTENT_RECLAIM
DB2_INDEX_CREATE_ALLOW_WRITE
DB2_REDUCE_FLUSHING_DURING_BACKUP
DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW
DB2_4K_DEVICE_SUPPORT
DB2_USE_ASYNC_FOR_MIRRORLOG

C:\Program Files\IBM\SQLLIB\BIN>

トラックバック


広告スペース
Google