DB2 Common Configuration

Db2set configuration:

Db2set Db2_enable_ldap=no

Db2set db2_alternate_group_lookup=getgrouplist

Db2set Db2_restore_grant_admin_authorities=on

Db2set Db2_skipinserted=on

Db2set db2_load_copy_no_override=nonrecoverable

Db2set Db2_evaluncommitted=on

Db2set Db2_skipdeleted=on

Db2set Db2comm=tcpip

Db2set DB2FCMCOMM=TCPIP4

Db2set db2_parallel_io=*

DBM Configuration:

DB2 DBM CFG USING SVCENAME db2c_inst1

DB2 DBM CFG USING maxagents 2000

DB2 DBM CFG USING num_initagents instance_memory Automatic

DB2 DBM CFG USING max_coordagents automatic max_connection Automatic

DB2 DBM CFG USING diagsize 1024

DB2 DBM CFG USING dft_mon_bufpool on Dft_mon_lock in Dft_mon_sort dft_mon_sort on dft_mon_stmt on dft_mon_table on DFT_MON _UOW on Health_mon OFF

DB configuration:

DB2 Update db CFG for $DBNAME USING Self_tuning_mem on

DB2 Update db CFG for $DBNAME USING database_memory AUTOMATIC

DB2 Update db CFG for $DBNAME USING locklist 524288

DB2 Update db CFG for $DBNAME USING MAXLOCKS 95

DB2 Update db CFG for $DBNAME USING LOCKTIMEOUT 300

DB2 Update db CFG for $DBNAME USING Mon_lw_thresh 10000

DB2 Update db CFG for $DBNAME USING MON_LCK_MSG_LVL 3

DB2 Update db CFG for $DBNAME USING mon_dealock hist_and_values

DB2 Update db CFG for $DBNAME USING mon_locktimeout hist_and_values

DB2 Update db CFG for $DBNAME USING mon_lockwait hist_and_values

DB2 Update db CFG for $DBNAME USING mon_act_metrics EXTENDED

DB2 Update db CFG for $DBNAME USING mon_req_metrics EXTENDED

DB2 Update db CFG for $DBNAME USING mon_obj_metrics EXTENDED

DB2 Update db CFG for $DBNAME USING MON_PKGLIST_SZ 1024

DB2 Update db CFG for $DBNAME USING mon_uow_data BASE

DB2 Update db CFG for $DBNAME USING cur_commit on

DB2 Update db CFG for $DBNAME USING rec_his RETENTN 31

DB2 Update db CFG for $DBNAME USING LOGFILSIZ 131072

Olap:

DB2 Update db CFG for $DBNAME USING LOGPRIMARY 56

DB2 Update db CFG for $DBNAME USING LOGSECOND 200

Oltp:

DB2 Update db CFG for $DBNAME USING LOGPRIMARY 10

DB2 Update db CFG for $DBNAME USING LOGSECOND 240

DB2 Update db CFG for $DBNAME USING Max_log 95

DB2 Update db CFG for $DBNAME USING Num_log_span 220

DB2 Update db CFG for $DBNAME USING sheapthres_shr AUTOMATIC

DB2 Update db CFG for $DBNAME USING STAT_HEAP_SZ AUTOMATIC

DB2 Update db CFG for $DBNAME USING SORTHEAP AUTOMATIC

DB2 Update db CFG for $DBNAME USING MAXAPPLS AUTOMATIC

DB2 Update db CFG for $DBNAME USING catalogcache_sz-1

DB2 Update db CFG for $DBNAME USING Pckcachesz AUTOMATIC

DB2 Update db CFG for $DBNAME USING appl_memory AUTOMATIC

DB2 Update db CFG for $DBNAME USING stmtheap AUTOMATIC

DB2 Update db CFG for $DBNAME USING UTIL_HEAP_SZ 32768

DB2 Update db CFG for $DBNAME USING auto_maint on

DB2 Update db CFG for $DBNAME USING auto_tbl_maint on

DB2 Update db CFG for $DBNAME USING auto_runstats on

DB2 10 or later configuration:

DB2 Update db CFG for $DBNAME USING LOGARCHCOMPR1 on

DB2 Update db CFG for $DBNAME USING mon_rtn_data BASE

DB2 Update db CFG for $DBNAME USING mon_rtn_execlist on

DB2 Update db CFG for $DBNAME USING mon_uow_execlist on

DB2 Update db CFG for $DBNAME USING mon_uow PKGLIST on

DB2 Update db CFG for $DBNAME USING UTIL_HEAP_SZ AUTOMATIC

DB2 Update db CFG for $DBNAME USING auto_sampling on

DB2 Update db CFG for $DBNAME USING auto_stats_views on

#批量执行该语句修改bufferpool

DB2 "SELECT ' Alter Bufferpool ' concat varchar (bpname,32) concat ' immediate size + automatic ' from Syscat.bufferpools with ur "Grep-i alter

DB2 Common Configuration