db2 - 查看数据库配置参数

语法：

 

get db cfg [for dbname]

 

举例：

 

db2 => get db cfg

 

       数据库  的数据库配置

 

 数据库配置发行版级别                                    = 0x0c00
 数据库发行版级别                                        = 0x0c00

 

 数据库地域                                              = CN
 数据库代码页                                            = 1208
 数据库代码集                                            = UTF-8
 数据库国家/地区代码                                    = 86
 数据库整理顺序                                          = IDENTITY
 备用整理顺序                              (ALT_COLLATE) =
 数字兼容性                                              = OFF
 Varchar2 兼容性                                         = OFF
 数据库页大小                                            = 4096

 

 动态 SQL 查询管理                      (DYN_QUERY_MGMT) = DISABLE

 

 对此数据库的发现支持                      (DISCOVER_DB) = ENABLE

 

 限制访问                                                = NO
 缺省查询优化类                           (DFT_QUERYOPT) = 5
 并行度                                     (DFT_DEGREE) = 1
 在算术异常时继续                      (DFT_SQLMATHWARN) = NO
 缺省刷新有效期                        (DFT_REFRESH_AGE) = 0
 缺省维护的选项（DFT_MTTB_TYPES）的表类型                = SYSTEM
 保留的高频值的数目                     (NUM_FREQVALUES) = 10
 保留的分位点数目                        (NUM_QUANTILES) = 20

 

 十进制浮点舍入方式                    (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 

 备份暂挂                                                = NO

 

 数据库是一致的                                          = NO
 前滚暂挂                                                = NO
 复原暂挂                                                = NO

 

 启用的多页文件分配                                      = YES

 

 恢复状态的日志保留                                      = NO
 日志记录状态的用户出口                                  = NO

 

 自调整内存                            (SELF_TUNING_MEM) = ON
 数据库共享内存大小（4KB）             (DATABASE_MEMORY) = AUTOMATIC
 数据库内存阈值                          (DB_MEM_THRESH) = 10
 锁定列表的最大存储量（4KB）                   (LOCKLIST) = AUTOMATIC
 每个应用程序的锁定百分比列表                 (MAXLOCKS) = AUTOMATIC
 程序包高速缓存大小（4KB）                  (PCKCACHESZ) = AUTOMATIC
 共享排序的排序堆域值（4KB）            (SHEAPTHRES_SHR) = AUTOMATIC
 排序列表堆（4KB）                            (SORTHEAP) = AUTOMATIC

 

 数据库堆（4KB）                                (DBHEAP) = AUTOMATIC
 目录高速缓存大小（4KB）               (CATALOGCACHE_SZ) = 260
 日志缓冲区大小（4KB）                         (LOGBUFSZ) = 98
 实用程序堆大小（4KB）                    (UTIL_HEAP_SZ) = 23665
 缓冲池大小（页࿰