安裝後的調整

DBM cfg
$> db2 "update dbm cfg using HEALTH_MON OFF"
$> db2 "update dbm cfg using DIAGSIZE 50"
DB cfg
## Turn some AUTO* options off
$> db2 "update db cfg for <db-name> using AUTO_MAINT off"
$> db2 "update db cfg for <db-name> using AUTO_TBL_MAINT off"
$> db2 "update db cfg for <db-name> using AUTO_RUNSTATS off"
$> db2 "update db cfg for <db-name> using AUTO_STMT_STATS off"

## Set the Active Log
$> db2 "update db cfg for DEVMMDB using LOGFILSIZ 12800"
$> db2 "update db cfg for DEVMMDB using LOGPRIMARY 10"
$> db2 "update db cfg for DEVMMDB using LOGSECOND 10"
$> db2 "update db cfg for DEVMMDB using NEWLOGPATH /home/devmm/DEVMMDB/log"
$> db2 "update db cfg for DEVMMDB using BLK_LOG_DSK_FUL YES" 

## If enabled HADR
$> db2 "update db cfg for <db-name> using BLOCKNONLOGGED yes"
重建一個新的 db2dump 目錄

為了要將 db2dump 目錄獨立出來,在新增目錄時必須加上一些特殊權限

$> mkdir db2dump
$> chmod 0777 db2dump
$> chmod g+s db2dump
$> chmod o+t db2dump
$> ls -l db2dump
drwxrwsrwt 3 istdw db2adm 4096 Aug 11 16:40 db2dump/