Db2 default values

Learn about the Db2 default values.

Container values

  • DB2_OBJECT_STORAGE_SETTINGS=ON
DB2_OBJECT_STORAGE_LOCAL_STAGING_PATH=$STAGING_PATH
DB2_WORKLOAD=ANALYTICS
DB2FODC='DUMPSHM=ON CORESHM=OFF'
DB2AUTH=OSAUTHDB
DB2_OBJECT_TABLE_ENTRIES=65532
DB2_LOAD_COPY_NO_OVERRIDE="COPY YES TO $LOAD_COPY_PATH"
DB2_FMP_RUN_AS_CONNECTED_USER=YES
DB2_ATS_ENABLE=YES
  • DIAGPATH     '"{DIAGPATH} $N"'
DIAGSIZE     300
SYSCTRL_GROUP     BLUADMIN
SYSMAINT_GROUP     BLUADMIN
SYSMON_GROUP     BLUADMIN
AUTHENTICATION     SERVER_ENCRYPT
DISCOVER     DISABLE
DISCOVER_INST     DISABLE
INSTANCE_USAGE    DASHDB
NUMDB     1
CONN_ELAPSE   60
MAX_CONNRETRIES   5
  • DFT_TABLE_ORG    COLUMN
LOGFILSIZ        50000
LOGPRIMARY       5
LOGSECOND        20
LOGARCHMETH1     "DISK:${ARCHLOGPATH}"
INDEXREC         ACCESS
PCKCACHESZ       65536
NUM_DB_BACKUPS   2
REC_HIS_RETENTN  2
AUTO_DEL_REC_OBJ ON

Default Db2 configuration settings specific to IAS for both column and row organized databases

  1. Column organized.
    • db configurations:
      AUTO_DEL_REC_OBJ ON
LOGFILSIZ 500000
LOCKLIST 65535
LOGPRIMARY 50
LOGSECOND 93
NUM_DB_BACKUPS 16
REC_HIS_RETENTN 91
TRACKMOD YES
PCKCACHESZ 65536
NEWLOGPATH /local/db2inst1
    • dbm configurations:
      START_STOP_TIME 5
DIAGSIZE 500
    • db2set.txt
      DB2_OBJECT_TABLE_ENTRIES=65536
DB2_EXTENDED_OPTIMIZATION="COL_PAR_IUD_DEGREE_FACTOR 1.5"
DB2_ALWAYS_START_IPV6_LISTENER=ON
  2. Row organized.
    • db configurations:
      AUTO_DEL_REC_OBJ ON
LOGFILSIZ 50000
LOCKLIST 65535
MAXLOCKS 60
SHEAPTHRES_SHR 4500000
SORTHEAP 235000
DFT_EXTENT_SZ 32
LOGPRIMARY 150
LOGSECOND 93
NUM_DB_BACKUPS 16
REC_HIS_RETENTN 91
TRACKMOD YES
PCKCACHESZ 65536
AUTO_REORG OFF
MON_OBJ_METRICS EXTENDED
DFT_TABLE_ORG ROW
NEWLOGPATH /local/db2inst1
LOGARCHMETH1 DISK:/scratch/db2archive/archive_log/
    • dbm configurations:
      START_STOP_TIME 5
FCM_NUM_BUFFERS 16384 AUTOMATIC
INTRA_PARALLEL YES
DIAGSIZE 500
    • db2set.text:
      DB2_WORKLOAD=PUREDATA_OLAP
DB2_CDE_REDUCED_LOGGING=REDUCED_REDO:NO
DB2COMPOPT=OJLOCALPRDPLANNING
DB2_SORT_AFTER_TQ=SCALAG
DB2_LOAD_COPY_NO_OVERRIDE=
DB2_EXTENDED_OPTIMIZATION="COL_PAR_IUD_DEGREE_FACTOR 1.5"
DB2_ALWAYS_START_IPV6_LISTENER=ON