GET DATABASE CONFIGURATION コマンド

GET DATABASE CONFIGURATION コマンドは、特定のデータベース構成ファイル内にある個々の項目の値を返します。

範囲

このコマンドは、コマンドが実行されたデータベース・パーティションに関する情報だけを返します。

許可

なし

必要な接続

インスタンス。 明示的な添付は必要ありませんが、SHOW DETAIL句を使う場合はデータベースへの接続が必要です。 データベースがリモートとして示されている場合、 リモート・ノードへのインスタンス・アタッチはコマンドの持続期間の間、 ずっと確立されたままになります。

コマンド構文

Read syntax diagramSkip visual syntax diagramGETDATABASEDBCONFIGURATIONCONFIGCFGFORdatabase-aliasSHOW DETAIL

コマンド・パラメーター

FOR database-alias
構成を表示したいデータベースの別名を指定します。 データベースへの接続が既に存在する場合、別名を指定する必要はありません。
SHOW DETAIL
データベース構成パラメーターの現行値と、次にデータベースをアクティブ化する際のパラメーター値が表示されます。 このオプションにより、構成パラメーターを動的に変更した結果が表示されます。

これは、CLPPlus インターフェースで操作する場合のデフォルトの節です。 CLPPlus プロセッサーを使う場合、SHOW DETAIL を呼び出す必要はありません。

SHOW DETAIL オプションが指定されない場合、このコマンドはDISKに保存される値のみを返します。この値は、メモリーの現行値と異なる可能性があります。

注: 例には、以下の点が適用されます。
  • プラットフォームが異なると、プラットフォーム固有のパラメーターを反映して、 出力の結果に微妙な違いが生じる場合があります。
  • パラメーターの値は、括弧で囲んだキーワードを使用して、UPDATE DATABASE CONFIGURATION コマンドで変更することができます。
  • キーワードを含まないフィールドは、 データベース・マネージャー によって保守され、更新することはできません。
  • 出力には製品の最新バージョンが反映されない場合もあります。
以下の出力例は、UNIX オペレーティング・システム上の Db2® pureScale® 環境の外部で GET DATABASE CONFIGURATION コマンドを実行することによって生成されたものです。
       Database Configuration for Database sample

 Database configuration release level                    = 0x1000
 Database release level                                  = 0x1000

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY
 Alternate collating sequence              (ALT_COLLATE) = 
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Date compatibility                                      = OFF
 Database page size                                      = 8192

 Statement concentrator                      (STMT_CONC) = OFF

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5
 Degree of parallelism                      (DFT_DEGREE) = 1
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO
 Default refresh age                   (DFT_REFRESH_AGE) = 0
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
 Number of frequent values retained     (NUM_FREQVALUES) = 10
 Number of quantiles retained            (NUM_QUANTILES) = 20

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 Backup pending                                          = NO

 All committed transactions have been written to disk    = YES
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(47088)
 Database memory threshold               (DB_MEM_THRESH) = 100
 Max storage for lock list (4KB)              (LOCKLIST) = 4096
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(1200)
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)
 Log buffer size (4KB)                        (LOGBUFSZ) = 256
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 5000
 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40000)
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(1)
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(3)
 Sequential detect flag                      (SEQDETECT) = YES
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC

 Track modified pages                         (TRACKMOD) = NO

 Default number of containers                            = 1
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)
 Max DB files open per application            (MAXFILOP) = 61440

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 10
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = /home/hotel84/jwr/jwr/NODE0000/SQL00001/LOGSTREAM0000/
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 First active log file                                   = 
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Block non logged operations            (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction  (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 Target for oldest page in LBP       (PAGE_AGE_TRGT_MCR) = 240

 HADR database role                                      = STANDARD
 HADR local host name                  (HADR_LOCAL_HOST) = 
 HADR local service name                (HADR_LOCAL_SVC) = 
 HADR remote host name                (HADR_REMOTE_HOST) = 
 HADR remote service name              (HADR_REMOTE_SVC) = 
 HADR instance name of remote server  (HADR_REMOTE_INST) = 
 HADR timeout value                       (HADR_TIMEOUT) = 120
 HADR target list                     (HADR_TARGET_LIST) = 
 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
 HADR spool log data limit (4KB)      (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds)     (HADR_REPLAY_DELAY) = 0
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

 First log archive method                 (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 
 Failover log archive path                (FAILARCHPATH) = 
 Number of log archive retries on error   (NUMARCHRETRY) = 5
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20
 Vendor options                              (VENDOROPT) = 

 Auto restart enabled                      (AUTORESTART) = ON
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
 Log pages during index build            (LOGINDEXBUILD) = OFF
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

 TSM management class                    (TSM_MGMTCLASS) = 
 TSM node name                            (TSM_NODENAME) = 
 TSM owner                                   (TSM_OWNER) = 
 TSM password                             (TSM_PASSWORD) = 

 Automatic maintenance                      (AUTO_MAINT) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
       Real-time statistics            (AUTO_STMT_STATS) = ON
       Statistical views              (AUTO_STATS_VIEWS) = OFF
       Automatic sampling                (AUTO_SAMPLING) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF

 Auto-Revalidation                          (AUTO_REVAL) = DEFERRED
 Currently Committed                        (CUR_COMMIT) = ON
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0
 Monitor Collect Settings
 Request metrics                       (MON_REQ_METRICS) = BASE
 Activity metrics                      (MON_ACT_METRICS) = BASE
 Object metrics                        (MON_OBJ_METRICS) = EXTENDED
 Routine data                             (MON_RTN_DATA) = NONE
   Routine executable list            (MON_RTN_EXECLIST) = OFF
 Unit of work events                      (MON_UOW_DATA) = NONE
   UOW events with package list        (MON_UOW_PKGLIST) = OFF
   UOW events with executable list    (MON_UOW_EXECLIST) = OFF
 Lock timeout events                   (MON_LOCKTIMEOUT) = NONE
 Deadlock events                          (MON_DEADLOCK) = WITHOUT_HIST
 Lock wait events                         (MON_LOCKWAIT) = NONE
 Lock wait event threshold               (MON_LW_THRESH) = 5000000
 Number of package list entries         (MON_PKGLIST_SZ) = 32
 Lock event notification level         (MON_LCK_MSG_LVL) = 1

 SMTP Server                               (SMTP_SERVER) = 
 SQL conditional compilation flags         (SQL_CCFLAGS) = 
 Section actuals setting               (SECTION_ACTUALS) = NONE
 Connect procedure                        (CONNECT_PROC) = 
 Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
 Log DDL Statements                      (LOG_DDL_STMTS) = NO
 Log Application Information             (LOG_APPL_INFO) = NO
 Default data capture on new Schemas   (DFT_SCHEMAS_DCC) = NO
 Default table organization              (DFT_TABLE_ORG) = ROW
 Default string units                     (STRING_UNITS) = SYSTEM
 National character string mapping       (NCHAR_MAPPING) = CHAR_CU32
 Database is in write suspend state                      = NO
 Extended row size support             (EXTENDED_ROW_SZ) = ENABLE

以下の例は、 Linux® オペレーティング・システム上の Db2 pureScale 環境で GET DATABASE CONFIGURATION コマンドを実行した後の出力例です。
       Database Configuration for Database sample

 Database configuration release level                    = 0x1000
 Database release level                                  = 0x1000

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY
 Alternate collating sequence              (ALT_COLLATE) = 
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Date compatibility                                      = OFF
 Database page size                                      = 8192

 Statement concentrator                      (STMT_CONC) = OFF

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5
 Degree of parallelism                      (DFT_DEGREE) = 1
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO
 Default refresh age                   (DFT_REFRESH_AGE) = 0
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
 Number of frequent values retained     (NUM_FREQVALUES) = 10
 Number of quantiles retained            (NUM_QUANTILES) = 20

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 Backup pending                                          = NO

 All committed transactions have been written to disk    = NO
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(280512)
 Database memory threshold               (DB_MEM_THRESH) = 100
 Max storage for lock list (4KB)              (LOCKLIST) = 4096
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(1200)
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)
 Log buffer size (4KB)                        (LOGBUFSZ) = 256
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 5000
 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40000)
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(1)
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(6)
 Sequential detect flag                      (SEQDETECT) = YES
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC

 Track modified pages                         (TRACKMOD) = NO

 Default number of containers                            = 1
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)
 Max DB files open per application            (MAXFILOP) = 61440

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 10
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = /home/hotel84/jwr/jwr/NODE0000/SQL00001/LOGSTREAM0000/
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 First active log file                                   = 
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Block non logged operations            (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction  (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 Target for oldest page in LBP       (PAGE_AGE_TRGT_MCR) = 120
 Target for oldest page in GBP       (PAGE_AGE_TRGT_GCR) = 240

 HADR database role                                      = STANDARD
 HADR local host name                  (HADR_LOCAL_HOST) = 
 HADR local service name                (HADR_LOCAL_SVC) = 
 HADR remote host name                (HADR_REMOTE_HOST) = 
 HADR remote service name              (HADR_REMOTE_SVC) = 
 HADR instance name of remote server  (HADR_REMOTE_INST) = 
 HADR timeout value                       (HADR_TIMEOUT) = 120
 HADR target list                     (HADR_TARGET_LIST) = 
 HADR log write synchronization mode     (HADR_SYNCMODE) = ASYNC
 HADR spool log data limit (4KB)      (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds)     (HADR_REPLAY_DELAY) = 0
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

 First log archive method                 (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 
 Failover log archive path                (FAILARCHPATH) = 
 Number of log archive retries on error   (NUMARCHRETRY) = 5
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20
 Vendor options                              (VENDOROPT) = 

 Auto restart enabled                      (AUTORESTART) = ON
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
 Log pages during index build            (LOGINDEXBUILD) = OFF
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

 TSM management class                    (TSM_MGMTCLASS) = 
 TSM node name                            (TSM_NODENAME) = 
 TSM owner                                   (TSM_OWNER) = 
 TSM password                             (TSM_PASSWORD) = 

 Automatic maintenance                      (AUTO_MAINT) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
       Real-time statistics            (AUTO_STMT_STATS) = ON
       Statistical views              (AUTO_STATS_VIEWS) = OFF
       Automatic sampling                (AUTO_SAMPLING) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF

 Auto-Revalidation                          (AUTO_REVAL) = DEFERRED
 CF Resource Configuration:
     CF database memory size (4KB)        (CF_DB_MEM_SZ) = AUTOMATIC(126464)
 Group buffer pool size (4KB)                (CF_GBP_SZ) = AUTOMATIC(78336)
 Directory-Entry-to-Data-Area ratio      (CF_DEDA_RATIO) = AUTOMATIC(4)
 Global lock memory size (4KB)              (CF_LOCK_SZ) = AUTOMATIC(19200)
 Shared communication area size (4KB)        (CF_SCA_SZ) = AUTOMATIC(26112)

 Catch up target for secondary CF (mins)(CF_CATCHUP_TRGT) = AUTOMATIC(15)

 Currently Committed                        (CUR_COMMIT) = ON
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0
 Monitor Collect Settings
 Request metrics                       (MON_REQ_METRICS) = BASE
 Activity metrics                      (MON_ACT_METRICS) = BASE
 Object metrics                        (MON_OBJ_METRICS) = EXTENDED
 Routine data                             (MON_RTN_DATA) = NONE
   Routine executable list            (MON_RTN_EXECLIST) = OFF
 Unit of work events                      (MON_UOW_DATA) = NONE
   UOW events with package list        (MON_UOW_PKGLIST) = OFF
   UOW events with executable list    (MON_UOW_EXECLIST) = OFF
 Lock timeout events                   (MON_LOCKTIMEOUT) = NONE
 Deadlock events                          (MON_DEADLOCK) = WITHOUT_HIST
 Lock wait events                         (MON_LOCKWAIT) = NONE
 Lock wait event threshold               (MON_LW_THRESH) = 5000000
 Number of package list entries         (MON_PKGLIST_SZ) = 32
 Lock event notification level         (MON_LCK_MSG_LVL) = 1

 SMTP Server                               (SMTP_SERVER) = 
 SQL conditional compilation flags         (SQL_CCFLAGS) = 
 Section actuals setting               (SECTION_ACTUALS) = NONE
 Connect procedure                        (CONNECT_PROC) = 
 Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
 Log DDL Statements                      (LOG_DDL_STMTS) = NO
 Log Application Information             (LOG_APPL_INFO) = NO
 Default data capture on new Schemas   (DFT_SCHEMAS_DCC) = NO
 Default table organization              (DFT_TABLE_ORG) = ROW
 Default string units                     (STRING_UNITS) = SYSTEM
 National character string mapping       (NCHAR_MAPPING) = CHAR_CU32
 Database is in write suspend state                      = NO
 Extended row size support             (EXTENDED_ROW_SZ) = ENABLE
 Optimize directed workloads          (OPT_DIRECT_WRKLD) = NO

以下の例は、 Db2 pureScale 環境で SHOW DETAIL オプションを指定した場合のコマンドの出力を示しています。 Delayed Value列の値は、次にインスタンスを起動したときに適用される値です。
       Database Configuration for Database sample

 Description                                  Parameter   Current Value              Delayed Value
 -------------------------------------------------------------------------------------------------
 Database configuration release level                    = 0x1000
 Database release level                                  = 0x1000

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY                   IDENTITY                  
 Alternate collating sequence              (ALT_COLLATE) =                                                      
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Date compatibility                                      = OFF
 Database page size                                      = 8192                       8192                      

 Statement concentrator                      (STMT_CONC) = OFF                        OFF                       

 Discovery support for this database       (DISCOVER_DB) = ENABLE                     ENABLE                    

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5                          5                         
 Degree of parallelism                      (DFT_DEGREE) = 1                          1                         
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO                         NO                        
 Default refresh age                   (DFT_REFRESH_AGE) = 0                          0                         
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM                     SYSTEM                    
 Number of frequent values retained     (NUM_FREQVALUES) = 10                         10                        
 Number of quantiles retained            (NUM_QUANTILES) = 20                         20                        

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN            ROUND_HALF_EVEN           

 Backup pending                                          = NO

 All committed transactions have been written to disk    = NO
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Self tuning memory                    (SELF_TUNING_MEM) = OFF                        OFF                       
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(280512)          AUTOMATIC(280512)         
 Database memory threshold               (DB_MEM_THRESH) = 100                        100                       
 Max storage for lock list (4KB)              (LOCKLIST) = 4096                       4096                      
 Percent. of lock lists per application       (MAXLOCKS) = 10                         10                        
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)               (MAXAPPLS*8)              
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000                       5000                      
 Sort list heap (4KB)                         (SORTHEAP) = 256                        256                       

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(1200)            AUTOMATIC(1200)           
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)               (MAXAPPLS*5)              
 Log buffer size (4KB)                        (LOGBUFSZ) = 256                        256                       
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 5000                       5000                      
 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)            AUTOMATIC(8192)           
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)             AUTOMATIC(256)            
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40016)           AUTOMATIC(40000)          
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)            AUTOMATIC(4384)           

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000                      10000                     
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1                         -1                        

 Changed pages threshold                (CHNGPGS_THRESH) = 60                         60                        
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(6)               AUTOMATIC(1)              
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(6)               AUTOMATIC(6)              
 Sequential detect flag                      (SEQDETECT) = YES                        YES                       
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC                  AUTOMATIC                 

 Track modified pages                         (TRACKMOD) = NO                         NO                        

 Default number of containers                            = 1                          1                         
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32                         32                        

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)              AUTOMATIC(40)             
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)               AUTOMATIC(1)              
 Max DB files open per application            (MAXFILOP) = 61440                      61440                     

 Log file size (4KB)                         (LOGFILSIZ) = 1000                       1000                      
 Number of primary log files                (LOGPRIMARY) = 3                          3                         
 Number of secondary log files               (LOGSECOND) = 10                         10                        
 Changed path to log files                  (NEWLOGPATH) =                                                      
 Path to log files                                       = /home/hotel84/jwr/jwr/     /home/hotel84/jwr/jwr/    
                                                           NODE0000/SQL00001/         NODE0000/SQL00001/
                                                           LOGSTREAM0000/	      LOGSTREAM0000/

 Overflow log path                     (OVERFLOWLOGPATH) =                                                      
 Mirror log path                         (MIRRORLOGPATH) =                                                      
 First active log file                                   =                                                      
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO                         NO                        
 Block non logged operations            (BLOCKNONLOGGED) = NO                         NO                        
 Percent max primary log space by transaction  (MAX_LOG) = 0                          0                         
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0                          0                         

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0                          0                         
 Target for oldest page in LBP       (PAGE_AGE_TRGT_MCR) = 120                        120                       
 Target for oldest page in GBP       (PAGE_AGE_TRGT_GCR) = 240                        240                       

 HADR database role                                      = STANDARD                   STANDARD                  
 HADR local host name                  (HADR_LOCAL_HOST) =                                                      
 HADR local service name                (HADR_LOCAL_SVC) =                                                      
 HADR remote host name                (HADR_REMOTE_HOST) =                                                      
 HADR remote service name              (HADR_REMOTE_SVC) =                                                      
 HADR instance name of remote server  (HADR_REMOTE_INST) =                                                      
 HADR timeout value                       (HADR_TIMEOUT) = 120                        120                       
 HADR target list                     (HADR_TARGET_LIST) =                                                      
 HADR log write synchronization mode     (HADR_SYNCMODE) = ASYNC                      ASYNC                     
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0                          0                         

 First log archive method                 (LOGARCHMETH1) = OFF                        OFF                       
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF                        OFF                       
 Options for logarchmeth1                  (LOGARCHOPT1) =                                                      
 Second log archive method                (LOGARCHMETH2) = OFF                        OFF                       
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF                        OFF                       
 Options for logarchmeth2                  (LOGARCHOPT2) =                                                      
 Failover log archive path                (FAILARCHPATH) =                                                      
 Number of log archive retries on error   (NUMARCHRETRY) = 5                          5                         
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20                         20                        
 Vendor options                              (VENDOROPT) =                                                      

 Auto restart enabled                      (AUTORESTART) = ON                         ON                        
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)           SYSTEM (RESTART)          
 Log pages during index build            (LOGINDEXBUILD) = OFF                        OFF                       
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1                          1                         
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12                         12                        
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366                        366                       
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF                        OFF                       

 TSM management class                    (TSM_MGMTCLASS) =                                                      
 TSM node name                            (TSM_NODENAME) =                                                      
 TSM owner                                   (TSM_OWNER) =                                                      
 TSM password                             (TSM_PASSWORD) =                                                      

 Automatic maintenance                      (AUTO_MAINT) = ON                         ON                        
   Automatic database backup            (AUTO_DB_BACKUP) = OFF                        OFF                       
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON                         ON                        
     Automatic runstats                  (AUTO_RUNSTATS) = ON                         ON                        
       Real-time statistics            (AUTO_STMT_STATS) = ON                         ON                        
       Statistical views              (AUTO_STATS_VIEWS) = OFF                        OFF                       
       Automatic sampling                (AUTO_SAMPLING) = OFF                        OFF                       
     Automatic reorganization               (AUTO_REORG) = OFF                        OFF                       

 Auto-Revalidation                          (AUTO_REVAL) = DEFERRED                   DEFERRED                  
 CF Resource Configuration:
     CF database memory size (4KB)        (CF_DB_MEM_SZ) = AUTOMATIC(126464)          AUTOMATIC(126464)         
 Group buffer pool size (4KB)                (CF_GBP_SZ) = AUTOMATIC(78336)           AUTOMATIC(78336)          
 Directory-Entry-to-Data-Area ratio      (CF_DEDA_RATIO) = AUTOMATIC(3)               AUTOMATIC(4)              
 Global lock memory size (4KB)              (CF_LOCK_SZ) = AUTOMATIC(19200)           AUTOMATIC(19200)          
 Shared communication area size (4KB)        (CF_SCA_SZ) = AUTOMATIC(26112)           AUTOMATIC(26112)          

 Catch up target for secondary CF (mins)(CF_CATCHUP_TRGT) = AUTOMATIC(15)              AUTOMATIC(15)             

 Currently Committed                        (CUR_COMMIT) = ON                         ON                        
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW                        NEW                       
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES                        YES                       
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0                          0                         

 Monitor Collect Settings
 Request metrics                       (MON_REQ_METRICS) = BASE                       BASE                      
 Activity metrics                      (MON_ACT_METRICS) = BASE                       BASE                      
 Object metrics                        (MON_OBJ_METRICS) = EXTENDED                   EXTENDED                  
 Routine data                             (MON_RTN_DATA) = NONE                       NONE                      
   Routine executable list            (MON_RTN_EXECLIST) = OFF                        OFF                       
 Unit of work events                      (MON_UOW_DATA) = NONE                       NONE                      
   UOW events with package list        (MON_UOW_PKGLIST) = OFF                        OFF                       
   UOW events with executable list    (MON_UOW_EXECLIST) = OFF                        OFF                       
 Lock timeout events                   (MON_LOCKTIMEOUT) = NONE                       NONE                      
 Deadlock events                          (MON_DEADLOCK) = WITHOUT_HIST               WITHOUT_HIST              
 Lock wait events                         (MON_LOCKWAIT) = NONE                       NONE                      
 Lock wait event threshold               (MON_LW_THRESH) = 5000000                    5000000                   

 Number of package list entries         (MON_PKGLIST_SZ) = 32                         32                        
 Lock event notification level         (MON_LCK_MSG_LVL) = 1                          1                         

 SMTP Server                               (SMTP_SERVER) =                                                      
 SQL conditional compilation flags         (SQL_CCFLAGS) =                                                      
 Section actuals setting               (SECTION_ACTUALS) = NONE                       NONE                      
 Connect procedure                        (CONNECT_PROC) =                                                      
 Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO                         NO                        
 Log DDL Statements                      (LOG_DDL_STMTS) = NO                         NO                        
 Log Application Information             (LOG_APPL_INFO) = NO                         NO                        
 Default data capture on new Schemas   (DFT_SCHEMAS_DCC) = NO                         NO                        
 HADR spool log data limit (4KB)      (HADR_SPOOL_LIMIT) = AUTOMATIC(0)               AUTOMATIC(0)              
 HADR log replay delay (seconds)     (HADR_REPLAY_DELAY) = 0                          0                         
 Default table organization              (DFT_TABLE_ORG) = ROW                        ROW                       
 Default string units                     (STRING_UNITS) = SYSTEM                     SYSTEM                    
 National character string mapping       (NCHAR_MAPPING) = CHAR_CU32                  CHAR_CU32                 
 Database is in write suspend state                      = NO
 Extended row size support             (EXTENDED_ROW_SZ) = ENABLE                     ENABLE                    
 Optimize directed workloads          (OPT_DIRECT_WRKLD) = NO                         NO                        
以下の例は、Windows オペレーティング・システムの Db2 環境で GET DATABASE CONFIGURATION コマンドを実行した後の出力例です。
       Database Configuration for Database sample

 Database configuration release level                    = 0x1000
 Database release level                                  = 0x1000

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY
 Alternate collating sequence              (ALT_COLLATE) = 
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Date compatibility                                      = OFF
 Database page size                                      = 8192

 Statement concentrator                      (STMT_CONC) = OFF

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5
 Degree of parallelism                      (DFT_DEGREE) = 1
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO
 Default refresh age                   (DFT_REFRESH_AGE) = 0
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
 Number of frequent values retained     (NUM_FREQVALUES) = 10
 Number of quantiles retained            (NUM_QUANTILES) = 20

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 Backup pending                                          = NO

 All committed transactions have been written to disk    = NO
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(44688)
 Database memory threshold               (DB_MEM_THRESH) = 100
 Max storage for lock list (4KB)              (LOCKLIST) = 4096
 Percent. of lock lists per application       (MAXLOCKS) = 22
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(600)
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)
 Log buffer size (4KB)                        (LOGBUFSZ) = 256
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 5000
 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40000)
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(1)
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(3)
 Sequential detect flag                      (SEQDETECT) = YES
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC

 Track modified pages                         (TRACKMOD) = NO

 Default number of containers                            = 1
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)
 Max DB files open per application            (MAXFILOP) = 65535

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 10
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = D:\DB3\NODE0000\SQL00001
                                                             \LOGSTREAM0000\
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 First active log file                                   = 
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Block non logged operations            (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction  (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 Target for oldest page in LBP       (PAGE_AGE_TRGT_MCR) = 240

 HADR database role                                      = STANDARD
 HADR local host name                  (HADR_LOCAL_HOST) = 
 HADR local service name                (HADR_LOCAL_SVC) = 
 HADR remote host name                (HADR_REMOTE_HOST) = 
 HADR remote service name              (HADR_REMOTE_SVC) = 
 HADR instance name of remote server  (HADR_REMOTE_INST) = 
 HADR timeout value                       (HADR_TIMEOUT) = 120
 HADR target list                     (HADR_TARGET_LIST) = 
 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
 HADR spool log data limit (4KB)      (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds)     (HADR_REPLAY_DELAY) = 0
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

 First log archive method                 (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 
 Failover log archive path                (FAILARCHPATH) = 
 Number of log archive retries on error   (NUMARCHRETRY) = 5
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20
 Vendor options                              (VENDOROPT) = 

 Auto restart enabled                      (AUTORESTART) = ON
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
 Log pages during index build            (LOGINDEXBUILD) = OFF
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

 TSM management class                    (TSM_MGMTCLASS) = 
 TSM node name                            (TSM_NODENAME) = 
 TSM owner                                   (TSM_OWNER) = 
 TSM password                             (TSM_PASSWORD) = 

 Automatic maintenance                      (AUTO_MAINT) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
       Real-time statistics            (AUTO_STMT_STATS) = ON
       Statistical views              (AUTO_STATS_VIEWS) = OFF
       Automatic sampling                (AUTO_SAMPLING) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF

 Auto-Revalidation                          (AUTO_REVAL) = DEFERRED
 Currently Committed                        (CUR_COMMIT) = ON
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0
 Monitor Collect Settings
 Request metrics                       (MON_REQ_METRICS) = BASE
 Activity metrics                      (MON_ACT_METRICS) = BASE
 Object metrics                        (MON_OBJ_METRICS) = EXTENDED
 Routine data                             (MON_RTN_DATA) = NONE
   Routine executable list            (MON_RTN_EXECLIST) = OFF
 Unit of work events                      (MON_UOW_DATA) = NONE
   UOW events with package list        (MON_UOW_PKGLIST) = OFF
   UOW events with executable list    (MON_UOW_EXECLIST) = OFF
 Lock timeout events                   (MON_LOCKTIMEOUT) = NONE
 Deadlock events                          (MON_DEADLOCK) = WITHOUT_HIST
 Lock wait events                         (MON_LOCKWAIT) = NONE
 Lock wait event threshold               (MON_LW_THRESH) = 5000000
 Number of package list entries         (MON_PKGLIST_SZ) = 32
 Lock event notification level         (MON_LCK_MSG_LVL) = 1

 SMTP Server                               (SMTP_SERVER) = 
 SQL conditional compilation flags         (SQL_CCFLAGS) = 
 Section actuals setting               (SECTION_ACTUALS) = NONE
 Connect procedure                        (CONNECT_PROC) = 
 Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
 Log DDL Statements                      (LOG_DDL_STMTS) = NO
 Log Application Information             (LOG_APPL_INFO) = NO
 Default data capture on new Schemas   (DFT_SCHEMAS_DCC) = NO
 Default table organization              (DFT_TABLE_ORG) = ROW
 Default string units                     (STRING_UNITS) = SYSTEM
 National character string mapping       (NCHAR_MAPPING) = CHAR_CU32
 Database is in write suspend state                      = NO
 Extended row size support             (EXTENDED_ROW_SZ) = ENABLE
重要: softmax データベース構成パラメーターは非推奨になっており、将来のリリースで削除される可能性があります。 詳しくは、 非推奨になったデータベース構成パラメーターを参照してください。

使用上の注意

データベース構成ファイルが無効である場合には、 データベースをバックアップ版からリストアしなければなりません。

データベース構成パラメーターを データベース・マネージャー のデフォルトに設定するには、 RESET DATABASE CONFIGURATION コマンドを使用します。

すべてのデータベース・パーティションから情報を取り出すには、SYSIBMADM.DBCFG 管理ビューを使用します。

GET DATABASE CONFIGURATION コマンドを発行して返される構成パラメーター値は、DISK に割り振られている構成パラメーター値とは若干異なる場合があります。