• 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