If the DB2_WORKLOAD registry variable has not been set which database manager configuration
parameter must be modified, before a query that accesses a column-organized table can be
executed?
A.
INTRA_PARALLEL
B.
QUERY_HEAP_SZ
C.
MAXIMUM DEGREE
D.
SHEAPTHRES SHR
SET DB2_WORKLOAD=ANALYTICS –> This will make all the table created by default as columnar store and set the below register key
Instance Parameter INTRA_PARALLEL=YES Enables intra-partition parallelism
Database Parameter DFT_TABLE_ORG=COLUMN
DFT_DEGREE=ANY : Enables intra-partition parallelism to use all detected cores
PAGESIZE=32768 : Default page size for table space or buffer pool if not specified
DFT_EXTENT_SZ=4 : The default extent size for a table space
SORTHEAP=[default+n] : Private sort heap [set higher than the default]
SHEAPTHRES_SHR=[default+n] : Shared sort heap [set higher than the default]
UTIL_HEAP_SZ=[default+n] : Utility heap [set higher than the default]
CATALOGCACHE_SZ=[default+n] : System catalog cache usage of the dbheap [set higher than the default]
AUTO_REORG=ON : Enables automatic REORGs for space reclamation
WLM objects : are created and set to maximize throughput
Read more at http://www.sqlpanda.com/2013/08/db2-105-blu-acceleration.html#lfT2qfwDCLBw8OaG.99
0
0
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.config.doc/doc/r0000140.html
0
0