Skip to main content

安裝後的調整

DBM cfg
$> db2 "update dbm cfg using HEALTH_MON OFF"
$> db2 "update dbm cfg using DIAGSIZE 50"
DB cfg
$> 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"

## 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/