Optimization of common parameters of DB2

Common parameter modification:

DB2 "Update db CFG for BMC using BUFFPAGE 51200"

DB2 ' alter Bufferpool IBMDEFAULTBP size 51200 '

DB2 "Update db CFG for BMC using LOGSECOND 200"

DB2 "Update db CFG for BMC using SORTHEAP 1024"

DB2 "Update db CFG for BMC using stmtheap 4096"

DB2 Update DB CFG for BMC using APPLHEAPSZ 1024

#如果未启动查查看/HOME/DB2INST/SQLLIB/DB2DUMP/DB2INST.NFY Log, and modify the maximum number of applications

DB2 Update DB CFG for BMC using MAXAPPLS 1000

DBM Parameter modification:

DB2 update dbm CFG using MON_HEAP_SZ 1000

DB2 update dbm CFG using JAVA_HEAP_SZ 4096

DB2 update dbm CFG using MAXAGENTS 200

Create an index eg:

DB2 "CREATE INDEX Stat_ss_type on stat.stat_score_2013 (type)"

This article from "I am a small Grass" blog, declined to reprint!

Optimization of common parameters of DB2