AIX上經(jīng)常使用的DB2建instance的語句

AIX上經(jīng)常使用的DB2建instance的語句:

#useradd -g db2iadm1 -m db2inst6
#useradd -g db2fadm1 -m db2fenc6
#db2icrt -u db2fenc6 -p 60034 db2inst6
#chuser fsize=-1 fsize_hard=-1 data=-1 data_hard=-1 stack=-1 stack_hard=-1 rss=-1 rss_hard=-1 nofiles=-1 nofiles_hard=-1 db2inst6-
 

#db2 get dbm cfg|grep -i svcename
#db2 update dbm cfg using SVCENAME DB2_db2inst6
#db2set -lr |grep -i db2comm=tcpip
#db2iauto -on db2inst6

打開self_tuning memory.

db2 update db cfg for sample using SELF_TUNING_MEM ON immediate
db2 get db cfg for sample |grep -i database_memory
db2 get db cfg for sample |grep -i sortheap
db2 get db cfg for sample |grep -i sheapthres_shr
db2 get db cfg for sample |grep -i locklist
db2 get db cfg for sample |grep -i self_tuning

db2 "update database configuration for sample using SELF_TUNING_MEM ON"
db2 "update database configuration for sample using PCKCACHESZ AUTOMATIC"
db2 "update database configuration for sample using LOCKLIST AUTOMATIC"
db2 "update database configuration for sample using MAXLOCKS automatic"
db2 "update database configuration for sample using SORTHEAP AUTOMATIC"
db2 "update database configuration for sample using SHEAPTHRES_SHR AUTOMATIC"
db2 "update database configuration for sample using DATABASE_MEMORY AUTOMATIC"

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]