那我想要了解DB2中的⼀些参数，所以想看看db2的配置⽂件，类似于mysql中的myf,postgresql中的f的地位的⽂件。 参考⽂章1：
1.SQLDBCONF ：数据库参数配置⽂件，使⽤ get db cfg/update db cfg 读取和修改数据。
2.SQLBP.*：缓冲池控制⽂件，使⽤ alter bufferpool 控制。
3.SQLSPCS.*：表空间控制⽂件，使⽤list/alter tablespace控制。
4.db2rhist.asc：数据库历史⽂件，使⽤LIST HISTORY浏览。
SQLOGCTL.LFH.*：数据库⽇志控制⽂件，⽆法浏览或⼈⼯修改。
参考⽂章2：
DB2可以在四个不同层⾯配置：
1.系统环境变量（System Environment Variable） 系统环境变量⽤来配置DB2的使⽤环境：
[db2inst1@localhost NODE0000]$ set | grep DB2
DB2DIR=/opt/ibm/db2/V11.1 --DB2的安装⽬录
DB2INSTANCE=db2inst1 --当前活动的实例 DB2LIB=/home/db2inst1/sqllib/lib
DB2_HOME=/home/db2inst1/sqllib
DB2_NET_CLIENT_PATH=
DB2INSTANCE环境变量介绍：
如果⼀个系统中有多个实例，那么如何在各个实例之间进⾏切换以及如何同时启动多个实例呢？这就需要DB2INSTANCE环境变量。环境变量是操作系统层⾯的，是在操作系统级别上定义的变量。最常使⽤的DB2环境变量是DB2INSTANCE。该环境变量运⾏您指定当前活动实例，所有命令都将 应⽤于
该实例。
配置实例
每个实例创建后，都有⼀个实例配置⽂件（db2system），这个实例配置⽂件控制实例的安全、通信、管理和资源的分配。我们可以根据需要来查看、更改和复位这个配置参数。这个配置⽂件是⼆进制的，只能通过命令来修改。
可以使⽤db2 get dbm cfg命令来查看当前实例配置参数。
db2 get dbm cfg命令显⽰的是在安装产品期间指定为默认配置参数的当前值，或在先前更新配置参数期间指定的那些值。
可以使⽤db2 update dbm cfg using ..来更新实例配置⽂件。
2.DB2概要⽂件注册表（profile registry）
有两种DB2概要⽂件注册表变量，⼀种是全局概要⽂件注册表变量，另⼀种是实例概要⽂件注册表变量。全局概要⽂件注册表变量影响所有的实例，实例概要⽂件注册表变量只影响特定的实例。它们的名称是相同的。DB2使⽤db2set命令来管理这些变量。DB2概要⽂件注册表⾮常多，但我们通常设置的却常少，如下：
显⽰所有DB2概要⽂件注册表变量：db2set -lr
显⽰当前设置的所有DB2概要⽂件注册表变量：db2set -all
帮助：db2set -?
设置变量：db2set <parameter>=<value>
常⽤的DB2概要⽂件注册表变量
DB2COMM
DB2SYSTEM
DB2INSTDEF
DB2ADMINSERVER
DB2 全局注册变量参数DB2ADMINSERVER定义了管理DB2数据库服务器的DAS（Database Administration Server）：
[db2inst1@localhost NODE0000]$ db2set -all | grep ADMINSERVER
[g] DB2ADMINSERVER=db2dasusr1
要启动或停⽌DAS，使⽤命令
db2admin start|stop
配置管理服务器：
查看：
[db2inst1@localhost NODE0000]$ db2 get admin cfg
Admin Server Configuration
Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT
DAS Administration Authority Group Name (DASADM_GROUP) =
DAS Discovery Mode (DISCOVER) = SEARCH
Name of the DB2 Server System (DB2SYSTEM) = BOGON
Java Development Kit Installation Path DAS (JDK_PATH) = AUTOMATIC (/home/db2dasusr1/das/java/jdk)
Java Development Kit Installation Path DAS (JDK_64_PATH) = AUTOMATIC (/home/db2dasusr1/das/java/jdk)
DAS Code Page (DAS_CODEPAGE) = 0
DAS Territory (DAS_TERRITORY) = 0
Location of Contact List (CONTACT_HOST) =
Execute Expired Tasks (EXEC_EXP_TASK) = NO
Scheduler Mode (SCHED_ENABLE) = OFF
SMTP Server (SMTP_SERVER) =
Tools Catalog Database (TOOLSCAT_DB) =
Tools Catalog Database Instance (TOOLSCAT_INST) =
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) =
Scheduler User ID =
Diagnostic error capture level (DIAGLEVEL) = 3
更新：
db2 update admin cfg using
3.数据库管理器配置（Database Manager Configuration）
以下参数⽤来配置实例：
查询命令：db2 get dbm cfg
设置命令：db2 update dbm cfg using <parameter_name> <value>
[db2inst1@localhost NODE0000]$ db2 get dbm cfg
Database Manager Configuration
Node type = Database Server with local and remote clients
Database manager configuration release level = 0x1400
CPU speed (millisec/instruction) (CPUSPEED) = 1.771291e-07
Max number of concurrently active databases (NUMDB) = 32
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /home/db2inst1/sqllib/java/jdk64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/sqllib/db2dump/
Current member resolved DIAGPATH = /home/db2inst1/sqllib/db2dump/
Alternate diagnostic data directory path (ALT_DIAGPATH) =
Current member resolved ALT_DIAGPATH =
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = OFF
SYSADM group name (SYSADM_GROUP) = DB2IADM1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Cluster manager =
Database manager authentication (AUTHENTICATION) = SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = /home/db2inst1
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90)
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Global instance memory (% or4KB) (INSTANCE_MEMORY) = AUTOMATIC(250188)
Member instance memory (% or4KB) = GLOBAL
Agent stack size (AGENT_STACK_SZ) = 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 0
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 65535
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10立军
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0电解质饮料
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS) Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = localhos
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
TCP/IP Service name (SVCENAME) = 50000
Discovery mode (DISCOVER) = SEARCH
空间Discover server instance (DISCOVER_INST) = ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
cnfSSL service name (SSL_SVCENAME) =
SSL cipher specs (SSL_CIPHERSPECS) =
SSL versions (SSL_VERSIONS) =
SSL client keydb file (SSL_CLNT_KEYDB) =
SSL client stash file (SSL_CLNT_STASH) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Number of FCM buffers (FCM_NUM_BUFFERS) = AUTOMATIC(1024)
FCM buffer size (FCM_BUFFER_SIZE) = 32768
Number of FCM channels (FCM_NUM_CHANNELS) = AUTOMATIC(512)
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
WLM dispatcher enabled (WLM_DISPATCHER) = NO
WLM dispatcher concurrency (WLM_DISP_CONCUR) = COMPUTED
WLM dispatcher CPU shares enabled (WLM_DISP_CPU_SHARES) = NO
WLM dispatcher min. utilization (%) (WLM_DISP_MIN_UTIL) = 5
Communication buffer exit library list (COMM_EXIT_LIST) =
Current effective arch level (CUR_EFF_ARCH_LVL) = V:11 R:1 M:1 F:1 I:0 SB:0
Current effective code level (CUR_EFF_CODE_LVL) = V:11 R:1 M:1 F:1 I:0 SB:0
Keystore type (KEYSTORE_TYPE) = NONE
Keystore location (KEYSTORE_LOCATION) =
管理(Administration)
AUTHENTICATION：数据库管理器认证(Database manager authentication)
CATALOG_NOAUTH：没有权限就允许编⽬(Cataloging allowed without authority)
CLNT_PW_PLUGIN：客户机⽤户标识-密码插件(Client Userid-Password Plugin)
CLNT_KRB_PLUGIN：客户机 Kerberos 插件(Client Kerberos Plugin)
CLUSTER_MGR：集管理器(Cluster manager)
DFTDBPATH：缺省数据库路径(Default database path)
FED_NOAUTH：绕过联合认证(Bypass federated authentication)
GROUP_PLUGIN：组插件(Group Plugin)
LOCAL_GSSPLUGIN：本地授权的 GSS 插件(GSS Plugin for Local Authorization)
SRV_PLUGIN_MODE：服务器插件⽅式(Server Plugin Mode)
SRVCON_GSSPLUGIN_LIST：GSS 插件的服务器列表(Server List of GSS Plugins)
SRVCON_PW_PLUGIN：服务器⽤户标识-密码插件(Server Userid-Password Plugin)
SYSADM_GROUP：SYSADM 组名(SYSADM group name)
SYSCTRL_GROUP：SYSCTRL 组名(SYSCTRL group name)
tough2SYSMAINT_GROUP：SYSMAINT 组名(SYSMAINT group name)
SYSMON_GROUP：SYSMON 组名(SYSMON group name)
TRUST_ALLCLNTS：信赖所有客户机(Trust all clients)
TRUST_CLNTAUTH：可信的客户机认证(Trusted client authentication)
应⽤程序(Applications)
AGENTPRI：代理程序的优先级(Priority of agents)
FENCED_POOL：合⽤受防护的进程的数⽬(Number of pooled fenced processes)
KEEPFENCED：保留受防护的进程(Keep fenced process)
MAX_CONNECTIONS：最⼤客户机连接数(Max number of client connections)
MAX_COORDAGENTS：最⼤协调代理程序数(Max number of coordinating agents)
NUM_INITAGENTS：池中的初始代理程序数(Initial number of agents in pool)
NUM_INITFENCED：受防护的进程的初始数⽬(Initial number of fenced processes)
1100.laNUM_POOLAGENTS：代理程序池⼤⼩(Agent pool size)
通信(Communications)
DISCOVER：发现⽅式(Discovery mode)
SVCENAME：TCP/IP 服务名称(TCP/IP Service name)
诊断(Diagnostic)
DIAGLEVEL：诊断错误捕获级别(Diagnostic error capture level)
DIAGPATH：诊断数据⽬录路径(Diagnostic data directory path)
INDEXREC：索引重新创建时间和重做索引构建(Index re-creation time and redo index build)
NOTIFYLEVEL：通知级别(Notify Level)
环境(Environment)
CPUSPEED：CPU 速度（毫秒/指令）(CPU speed (millisec/instruction))
DFT_ACCOUNT_STR：缺省对⽅付费帐户(Default charge-back account)
DISCOVER_INST：发现服务器实例(Discover server instance)
FEDERATED：联合数据库系统⽀持(Federated Database System Support)
JDK_PATH：<a href="lib.csdn/base/17"class='replace_word' title="Java EE知识库" target='_blank' style='color:#df3434; font-weight:bold;' MAXTOTFILOP：最⼤打开⽂件数
NUMDB：最⼤并发活动数据库数(Max number of concurrently active databases)
TM_DATABASE：事务管理器数据库名称(Transaction manager database name)
TP_MON_NAME：事务处理器监视器名(Transaction processor monitor name)
监视(Monitor)
DFT_MON_BUFPOOL：缓冲池(Buffer pool)
DFT_MON_LOCK：锁定(Lock)
DFT_MON_SORT：排序(Sort)
DFT_MON_STMT：语句(Statement)
DFT_MON_TABLE：表(Table)
DFT_MON_TIMESTAMP：时间戳记(Timestamp)
DFT_MON_UOW：⼯作单元(Unit of work)
豫公网安备41160202000603
站长QQ:729038198
关于我们
投诉建议