GET DATABASE MANAGER CONFIGURATION 命令
GET DATABASE MANAGER CONFIGURATION 命令返回 数据库管理器 配置文件中各个条目的值。
授权
无
需要的连接
无或实例。 执行本地 数据库管理器 配置操作不需要实例连接，但执行远程 数据库管理器 配置操作需要实例连接。 要显示远程实例的 数据库管理器 配置，必须首先连接到该实例。 SHOW DETAIL 子句需要实例连接。
命令语法
命令参数
- SHOW DETAIL
- 显示数据库配置参数的当前值以及下次启动数据库管理器时将使用的参数的值。 此选项显示动态更改配置参数的结果。
这是在 CLPPlus 接口中运行时的缺省子句。 使用 CLPPlus 处理器时无需调用 SHOW DETAIL 。
示例
节点类型和平台都确定列出了哪些配置参数。
以下示例是在 Linux® 操作系统上运行 GET DATABASE MANAGER CONFIGURATION 命令后的输出示例。 Db2 pureScale® 实例：
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0e00
CPU speed (millisec/instruction) (CPUSPEED) = 4.000000e-05
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Max number of concurrently active databases (NUMDB) = 1
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/hotel67/db2inst1/sqllib/db2dump/ $m
Current member resolved DIAGPATH = /home/hotel67/db2inst1/sqllib/db2dump/DIAG0000
Alternate diagnostic data directory path (ALT_DIAGPATH) = /home/hotel67/db2inst1/sqllib/db2altdump/ $m
Current member resolved ALT_DIAGPATH = /home/hotel67/db2inst1/sqllib/db2altdump/DIAG0000
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) = DB2ADMIN
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 = TSA
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)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(1705741)
Instance memory for restart light (%) (RSTRT_LIGHT_MEM) = AUTOMATIC(10)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
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
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
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) =
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) =
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) =
SSL 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
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048)
Node connection elapse time (sec) (CONN_ELAPSE) = 3
Max number of node connection retries (MAX_CONNRETRIES) = 3
Max time difference between nodes (min) (MAX_TIME_DIFF) = 1
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
CF Server Configuration:
Memory size (4KB) (CF_MEM_SZ) = AUTOMATIC
Number of worker threads (CF_NUM_WORKERS) = AUTOMATIC
Number of connections (CF_NUM_CONNS) = AUTOMATIC
Diagnostic error capture level (CF_DIAGLEVEL) = 2
Diagnostic data directory path (CF_DIAGPATH) = /home/hotel67/db2inst1/sqllib/db2dump/ $m
Current member resolved CF_DIAGPATH = /home/hotel67/db2inst1/sqllib/db2dump/DIAG0000/以下输出样本显示指定 SHOW DETAIL 选项时显示的信息。 Delayed
Value 列中显示的值是下次启动数据库管理器实例时生效的值。
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database manager configuration release level = 0x0e00
CPU speed (millisec/instruction) (CPUSPEED) = 4.000000e-05 4.000000e-05
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02 1.000000e+02
Max number of concurrently active databases (NUMDB) = 1 1
Federated Database System Support (FEDERATED) = NO 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 /home/db2inst1/sqllib/java/jdk64
Diagnostic error capture level (DIAGLEVEL) = 3 3
Notify Level (NOTIFYLEVEL) = 3 3
Diagnostic data directory path (DIAGPATH) = /home/hotel67/db2inst1/sqllib/db2dump/ $m
Current member resolved DIAGPATH = /home/hotel67/db2inst1/sqllib/db2dump/DIAG0000
Alternate diagnostic data directory path (ALT_DIAGPATH) = /home/hotel67/db2inst1/sqllib/db2altdump/ $m
Current member resolved ALT_DIAGPATH = /home/hotel67/db2inst1/sqllib/db2altdump/DIAG0000
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0 0
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF OFF
Lock (DFT_MON_LOCK) = OFF OFF
Sort (DFT_MON_SORT) = OFF OFF
Statement (DFT_MON_STMT) = OFF OFF
Table (DFT_MON_TABLE) = OFF OFF
Timestamp (DFT_MON_TIMESTAMP) = ON ON
Unit of work (DFT_MON_UOW) = OFF OFF
Monitor health of instance and databases (HEALTH_MON) = OFF OFF
SYSADM group name (SYSADM_GROUP) = DB2ADMIN DB2ADMIN
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 UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED NOT_SPECIFIED
Cluster manager = TSA TSA
Database manager authentication (AUTHENTICATION) = SERVER SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED NOT_SPECIFIED
Cataloging allowed without authority (CATALOG_NOAUTH) = NO NO
Trust all clients (TRUST_ALLCLNTS) = YES YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT CLIENT
Bypass federated authentication (FED_NOAUTH) = NO NO
Default database path (DFTDBPATH) = /home/db2inst1 /home/db2inst1
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90) AUTOMATIC(90)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(1705741) AUTOMATIC(1705741)
Instance memory for restart light (%) (RSTRT_LIGHT_MEM) = AUTOMATIC(10) AUTOMATIC(10)
Agent stack size (AGENT_STACK_SZ) = 1024 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 0 0
Directory cache support (DIR_CACHE) = YES YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15 15
Max requester I/O block size (bytes) (RQRIOBLK) = 65535 65535
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10 10
Priority of agents (AGENTPRI) = SYSTEM SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100) AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0 0
Index re-creation time and redo index build (INDEXREC) = RESTART RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180 180
SPM name (SPM_NAME) =
SPM log size (SPM_LOG_FILE_SZ) = 256 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20 20
SPM log path (SPM_LOG_PATH) =
TCP/IP Service name (SVCENAME) =
Discovery mode (DISCOVER) = SEARCH SEARCH
Discover server instance (DISCOVER_INST) = ENABLE ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
SSL 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 ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096) AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048) AUTOMATIC(2048)
Node connection elapse time (sec) (CONN_ELAPSE) = 3 3
Max number of node connection retries (MAX_CONNRETRIES) = 3 3
Max time difference between nodes (min) (MAX_TIME_DIFF) = 1 1
db2start/db2stop timeout (min) (START_STOP_TIME) = 10 10
CF Server Configuration:
Memory size (4KB) (CF_MEM_SZ) = AUTOMATIC(131072) AUTOMATIC(131072)
Number of worker threads (CF_NUM_WORKERS) = AUTOMATIC(1) AUTOMATIC(1)
Number of connections (CF_NUM_CONNS) = AUTOMATIC(19) AUTOMATIC(19)
Diagnostic error capture level (CF_DIAGLEVEL) = 2 2
Diagnostic data directory path (CF_DIAGPATH) = /home/hotel67/db2inst1/sqllib/ $m
Current member resolved CF_DIAGPATH = /home/hotel67/db2inst1/sqllib/db2dump/DIAG0000/以下示例是在 Windows 操作系统上运行 GET DATABASE MANAGER CONFIGURATION 命令后的样本输出:
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0c00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) = 4.251098e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+002
Max number of concurrently active databases (NUMDB) = 8
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) =
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
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) = ON
SYSADM group name (SYSADM_GROUP) =
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) = IBMkrb5
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 (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER
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) = C:
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
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
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC
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) = KEON14
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10以下输出样本显示在 Windows 操作系统上指定 SHOW DETAIL 选项时显示的信息。 Delayed Value 列中显示的值是下次启动数据库管理器实例时生效的值。
db2 => get dbm cfg show detail
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------
Database manager configuration release level = 0x0c00
Maximum total of files open (MAXTOTFILOP) = 16000 16000
CPU speed (millisec/instruction) (CPUSPEED) = 4.251098e-007 4.251098e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+002 1.000000e+002
Max number of concurrently active databases (NUMDB) = 8 8
Federated Database System Support (FEDERATED) = NO NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) =
Diagnostic error capture level (DIAGLEVEL) = 3 3
Notify Level (NOTIFYLEVEL) = 3 3
Diagnostic data directory path (DIAGPATH) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF OFF
Lock (DFT_MON_LOCK) = OFF OFF
Sort (DFT_MON_SORT) = OFF OFF
Statement (DFT_MON_STMT) = OFF OFF
Table (DFT_MON_TABLE) = OFF OFF
Timestamp (DFT_MON_TIMESTAMP) = ON ON
Unit of work (DFT_MON_UOW) = OFF OFF
Monitor health of instance and databases (HEALTH_MON) = ON ON
SYSADM group name (SYSADM_GROUP) =
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) = IBMkrb5 IBMkrb5
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED NOT_SPECIFIED
Cluster manager (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO NO
Trust all clients (TRUST_ALLCLNTS) = YES YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT CLIENT
Bypass federated authentication (FED_NOAUTH) = NO NO
Default database path (DFTDBPATH) = C: C:
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(66) AUTOMATIC(66)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(73728) AUTOMATIC(73728)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024 1024
Agent stack size (AGENT_STACK_SZ) = 16 16
Sort heap threshold (4KB) (SHEAPTHRES) = 0 0
Directory cache support (DIR_CACHE) = YES YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15 15
Max requester I/O block size (bytes) (RQRIOBLK) = 65535 65535
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10 10
Priority of agents (AGENTPRI) = SYSTEM SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100) AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_ AUTOMATIC(MAX_
COORDAGENTS) COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_ AUTOMATIC(MAX_
COORDAGENTS) COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0 0
Index re-creation time and redo index build (INDEXREC) = RESTART RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180 180
SPM name (SPM_NAME) = KEON14 KEON14
SPM log size (SPM_LOG_FILE_SZ) = 256 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2 db2c_DB2
Discovery mode (DISCOVER) = SEARCH SEARCH
Discover server instance (DISCOVER_INST) = ENABLE ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096) AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048) AUTOMATIC(2048)
Node connection elapse time (sec) (CONN_ELAPSE) = 10 10
Max number of node connection retries (MAX_CONNRETRIES) = 5 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10 10使用说明
- 如果存在与远程实例或其他本地实例的连接，那么将返回所连接服务器的 数据库管理器 配置参数的值。 否则，将返回本地 数据库管理器 配置参数的值。
- 如果发生错误，那么返回的信息无效。 如果配置文件无效，那么将返回错误消息。 用户必须删除并重新创建要恢复的实例。
- 要将配置参数设置为数据库管理器 随附的缺省值，请使用 RESET DATABASE MANAGER CONFIGURATION 命令。
- GET DATABASE MANAGER CONFIGURATION SHOW DETAIL 上针对 fcm_num_buffers 和 fcm_num_channels 指示的 AUTOMATIC 值是实例启动时的初始值，不反映运行时可能发生的任何自动增大或减小。
- 配置参数 max_connections， max_coordagents和 num_poolagents 设置为 AUTOMATIC。
- 不推荐使用配置参数 maxagents 和 maxcagents 。 结果是以下不推荐使用的函数:
- CLP 和 db2CfgSet API 将容许对这些参数进行更新。 但这些更新将被 Db2® 数据库。
- 当客户机和服务器位于 Db2 V9.5 代码库中时， CLP 将不再显示这些数据库配置参数。 如果服务器为 Db2 V9.5，那么对于较早的客户机，这些参数的值似乎为 0 输出。 如果客户机是 Db2 V9.5，但服务器早于 Db2 V9.5，那么将显示这些参数以及分配的值。
- db2CfgGet API 将容许对 SQLF_KTN_MAXAGENTS 和 SQLF_KTN_MAXCAGENTS 的请求，但如果服务器为 Db2 V9.5，那么它们将返回 0。
- db2AutoConfig API 的行为将取决于传入到 API 的 db2VersionNumber 。 如果版本为 Db2 V9.5 或更高版本，那么将不会返回 maxagents ，但对于低于此版本的版本将返回。
- AUTOCONFIGURE CLP 命令将显示 maxagents 的值以及来自较早版本客户机的请求 (当前值和建议值 0)。 对于当前版本的客户机请求，将显示具有相应值的 maxagents 。
- 当服务器为 Db2 V9.5 或更高版本时， AUTOCONFIGURE ADMIN_CMD 过程将不会返回有关 maxagents 的信息。
- 如果服务器为 Db2 V9.5 或更高版本，那么通过 ADMIN_CMD 过程对 maxagents 或 maxcagents 的更新将成功返回，但对服务器没有任何影响。
- 如果服务器为 Db2 V9.5 或更高版本，那么使用 DBMCFG 管理视图的数据库管理器配置参数查询将不会返回 maxagents 或 maxcagents 的行。
在将来的发行版中，可能会完全除去这些配置参数。