
db2 connect to specdb user db2inst1 using jdk123

db2 update dbm cfg using MAXAGENTS 2000
db2 update dbm cfg using MAX_QUERYDEGREE 1
db2 update dbm cfg using DFT_MON_LOCK OFF
db2 update dbm cfg using DFT_MON_STMT OFF
db2 update dbm cfg using DFT_MON_TABLE OFF
db2 update dbm cfg using DFT_MON_UOW OFF

db2 update db cfg for specdb using dft_queryopt 0
db2 update db cfg for specdb using dbheap 64000
db2 update db cfg for specdb using logbufsz 4096
db2 update db cfg for specdb using buffpage 200000
db2 update db cfg for specdb using seqdetect NO
db2 update db cfg for specdb using num_ioservers 1
db2 update db cfg for specdb using logfilsiz 20000
db2 update db cfg for specdb using logprimary 10
db2 update db cfg for specdb using MAXAPPLS 2000
db2 update db cfg for specdb using MAXLOCKS 100
db2 update db cfg for specdb using LOCKLIST 4006

db2 update db cfg for specdb using STMTHEAP 4096
db2 update db cfg for specdb using LOGFILSIZ 65535
db2 update db cfg for specdb using LOGPRIMARY 6

db2 update db cfg for specdb using CHNGPGS_THRESH 99
db2 update db cfg for specdb using SOFTMAX 200
db2 update db cfg for specdb using NUM_IOCLEANERS 4

db2 update db cfg for specdb using newlogpath /dev/rdb2loglv

db2 alter bufferpool ibmdefaultbp size -1
db2 alter table m_largeorder volatile
db2 reorgchk update statistics on table all

db2 update dbm cfg using diaglevel 1

db2 commit work
db2 connect reset
db2 terminate

