GET DATABASE MANAGER CONFIGURATION コマンド
GET DATABASE MANAGER CONFIGURATION コマンドは、 データベース・マネージャー 構成ファイル内の個々の項目の値を戻します。
許可
なし
必要な接続
なし、またはインスタンス。 インスタンス接続は、ローカル データベース・マネージャー 構成操作を実行するためには必要ありませんが、リモート データベース・マネージャー 構成操作を実行するためには必要です。 リモート・インスタンスの データベース・マネージャー 構成を表示するには、まずそのインスタンスにアタッチする必要があります。 SHOW DETAIL 節には、インスタンス接続が必要です。
コマンド構文
コマンド・パラメーター
- SHOW DETAIL
- データベース構成パラメーターの現行値と、次にデータベース・マネージャーを開始するときに使用されるパラメーター値が表示されます。 このオプションにより、構成パラメーターを動的に変更した結果が表示されます。
これは、CLPPlus インターフェースで操作する場合のデフォルトの節です。 CLPPlus プロセッサーを使う場合、SHOW DETAIL を呼び出す必要はありません。
例
ノード・タイプとプラットフォームによって、どの構成パラメーターをリストするかが決まります。
以下の例は、 Db2® pureScale® インスタンスを使用して Linux® オペレーティング・システムで GET DATABASE MANAGER CONFIGURATION コマンドを実行した後の出力例です。
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 コマンドを使用します。
- fcm_num_buffers および fcm_num_channels の GET DATABASE MANAGER CONFIGURATION SHOW DETAIL に示されている 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 は適切な値で表示されます。
- AUTOCONFIGURE ADMIN_CMD プロシージャーは、サーバーが Db2 V9.5 以降の場合、 maxagents に関する情報を戻しません。
- ADMIN_CMD プロシージャーによる maxagents または maxcagents への更新は正常に戻されますが、サーバーが Db2 V9.5 以上の場合、そうした更新はサーバーに対して無効です。
- サーバーが Db2 V9.5 以降の場合、DBMCFG 管理ビューを使用するデータベース・マネージャー構成パラメーターの照会では、 maxagents または maxcagents の行は返されません。
今後のリリースでは、これらの構成パラメーターは完全に除去される予定です。