Sort list heap (4KB) (SORTHEAP) = AUTOMATIC 47808
SQL statement heap (4KB) (STMTHEAP) = 8192 16384
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 4384
Utilities heap size (4KB) (UTIL_HEAP_SZ) = AUTOMATIC AUTOMATIC
Self tuning memory (SELF_TUNING_MEM) = ON ON
Automatic runstats (AUTO_RUNSTATS) = ON ON
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC 956160
Log buffer size (4KB) (LOGBUFSZ) = 2152 2152
Default table organization (DFT_TABLE_ORG) = ROW COLUMN
Database memory threshold (DB_MEM_THRESH) = 100 100
Former and Applied Values for Bufferpool(s)
Description Parameter Former Value Applied Value
-------------------------------------------------------------------------------------------------
IBMDEFAULTBP Bufferpool size = -2 119520
Former and Applied Values for System WLM Objects
Description Former Value Applied Value
-------------------------------------------------------------------------------------------------
Work Action SYSMAPMANAGEDQUERIES Enabled = Y Y
Work Action Set SYSDEFAULTUSERWAS Enabled = Y Y
Work Class SYSMANAGEDQUERIES Timeroncost = 1.50000E+05 1.50000E+05
Threshold SYSDEFAULTCONCURRENT Enabled = N Y
Threshold SYSDEFAULTCONCURRENT Maxvalue = 13 13
DB210203I AUTOCONFIGURE completed successfully. Database manager or database
configuration values may have been changed if you chose to apply changes. The
instance must be restarted before any such applied changes come into effect.
You may also want to rebind your packages after the new configuration
parameters take effect so that the new values will be used.
可以看到DFT_TABLE_ORG的值由row修改为column了，也就是以后创建的表默认就是列式存储表了，据测试来看列式存储确实在空间使用和SQL查询效率上提高了很多，不过改特性只能支持单表的，对于分表/DPF/MDC/PureScale环境下的表还是不能支持的，好，现在就说初步了解下，以后会有更多的实际应用案例吧。