GET DATABASE MANAGER CONFIGURATION コマンド

GET DATABASE MANAGER CONFIGURATION コマンドは、 データベース・マネージャー 構成ファイル内の個々の項目の値を戻します。

許可

なし

必要な接続

なし、またはインスタンス。 インスタンス接続は、ローカル データベース・マネージャー 構成操作を実行するためには必要ありませんが、リモート データベース・マネージャー 構成操作を実行するためには必要です。 リモート・インスタンスの データベース・マネージャー 構成を表示するには、まずそのインスタンスにアタッチする必要があります。 SHOW DETAIL 節には、インスタンス接続が必要です。

コマンド構文

Read syntax diagramSkip visual syntax diagramGET DATABASE MANAGERDB MANAGERDBM CONFIGURATIONCONFIGCFG 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_channelsGET DATABASE MANAGER CONFIGURATION SHOW DETAIL に示されている AUTOMATIC 値は、インスタンスの起動時の初期値であり、実行時に発生した可能性のある自動的な増加または減少を反映していません。
  • 構成パラメーター max_connectionsmax_coordagentsnum_poolagentsAUTOMATICに設定されます。
  • 構成パラメーター maxagentsmaxcagents は推奨されません。 推奨されない関数を使用すると、次のようになります。
    • 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 の行は返されません。

    今後のリリースでは、これらの構成パラメーターは完全に除去される予定です。