What does setting DB2_WORKLOAD=ANALYTICS do in Db2 BLU Acceleration?

Database page size set by CREATE DATABASE statement is 32KB
DFT_TABLE_ORG DB CFG parameter is set to COLUMN
DFT_EXTENT_SZ DB CFG parameter is set to 4
DFT_DEGREE DB CFG parameter is set to ANY
Intra query parallelism is enabled for any workload even if INTRA_PARALLEL DBM CFG parameter set to NO
CATALOGCACHE_SZ DB CFG parameter will actually be 20% larger than usual
SORTHEAP and SHEAPTHRES_SHR DB CFG parameters will be calculated based on server memory. The starting value for SHEAPTHRES_SHR is the sum of all the buffer pools in the database and SORTHEAP will be 1/20 of SHEAPTHRESH_SHR. These will not be set to AUTOMATIC.
UTIL_HEAP_SZ DB CFG parameter will be set to 1 million pages and AUTOMATIC
AUTO_REORG DB CFG parameter will be set to ON for space reclaim

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

EnterpriseDB2