dd if=/dev/zero of=/dev/rloglv bs=4096k count=21
db2set DB2SPINLATCHES=0:0
db2set DB2_LARGE_PAGE_MEM=DB
db2set DB2_APM_PERFORMANCE=on
db2set DB2_SKIPINSERTED=on
db2set DB2_MAX_NON_TABLE_LOCKS=1000 #4000
db2set DB2_KEEPTABLELOCK=ON
db2set DB2COMM=tcpip
db2 -v update dbm cfg using diaglevel 3
db2 -v update dbm cfg using notifylevel 3
db2 -v update dbm cfg using rqrioblk 65535
db2 -v update dbm cfg using DFT_MON_BUFPOOL on DFT_MON_LOCK off DFT_MON_SORT off DFT_MON_STMT off DFT_MON_TIMESTAMP off DFT_MON_UOW off DFT_MON_TABLE off
db2 -v update dbm cfg using HEALTH_MON off NUM_INITAGENTS 5200 NUM_POOLAGENTS 5200 MAX_COORDAGENTS 5200 MAX_CONNECTIONS 5200 
db2 -v update dbm cfg using cpuspeed -1
db2 -v update dbm cfg using diagpath /specdata2
db2 -v connect to specdb
db2 -v update db cfg for specdb using dft_queryopt 1
db2 -v update db cfg for specdb using dft_degree 1
db2 -v update db cfg using catalogcache_sz 260
db2 -v update db cfg using logbufsz 4096
db2 -v update db cfg for specdb using num_iocleaners 40 
db2 -v update db cfg for specdb using num_ioservers 6 
db2 -v update db cfg for specdb using logfilsiz 524286 
db2 -v update db cfg for specdb using logsecond 0
db2 -v update db cfg for specdb using logprimary 256
db2 -v update db cfg for specdb using newlogpath /dev/rloglv
db2 -v update db cfg for specdb using softmax 500
db2 -v update db cfg for specdb using chngpgs_thresh 60
db2 -v update db cfg for specdb using auto_maint off
db2 -v update db cfg for specdb using AUTO_RUNSTATS off
db2 -v update db cfg for specdb using AUTO_TBL_MAINT off
db2 -v update db cfg for specdb using maxlocks 100 locklist 18000
db2 -v update db cfg for specdb using maxappls 5200 avg_appls 5200
db2 -v update db cfg for specdb using dbheap 128000
db2 -v update db cfg for specdb using database_memory 46633600
db2 -v update db cfg for specdb using self_tuning_mem off
db2 -v update db cfg for specdb using pckcachesz 51200
db2 -v update db cfg for specdb using sheapthres_shr 192843
db2 -v update db cfg for specdb using sortheap 46000
db2 -v alter tablespace TEMPSPACE1 prefetchsize 8M
db2 -v alter tablespace USERSPACE1 prefetchsize 8M
db2 -v alter tablespace ROLL_SPACE prefetchsize 8M
db2 -v alter tablespace C_CUSTINV_SPACE prefetchsize 8M
db2 -v alter tablespace C_CI_IDX_SPACE prefetchsize 8M 
db2 -v alter tablespace C_CUST_SPACE prefetchsize 8M
db2 -v alter tablespace C_C_IDX_SPACE prefetchsize 8M
db2 -v alter tablespace C_SUPP_SPACE prefetchsize 8M
db2 -v alter tablespace C_SUPP_IDX_SPACE prefetchsize 8M
db2 -v alter tablespace C_SITE_SPACE prefetchsize 8M
db2 -v alter tablespace C_SITE_IDX_SPACE prefetchsize 8M
db2 -v alter tablespace C_PARTS_SPACE prefetchsize 8M
db2 -v alter tablespace C_P_IDX_SPACE prefetchsize 8M
db2 -v alter tablespace M_parts_SPACE prefetchsize 8M
db2 -v alter tablespace M_parts_idx_SPACE prefetchsize 8M
db2 -v alter tablespace M_bom_SPACE prefetchsize 8M
db2 -v alter tablespace M_bom_idx_SPACE prefetchsize 8M
db2 -v alter tablespace M_wo_SPACE prefetchsize 8M
db2 -v alter tablespace M_wo_idx_SPACE prefetchsize 8M
db2 -v alter tablespace M_lo_idx_SPACE prefetchsize 8M
db2 -v alter tablespace M_lo_SPACE prefetchsize 8M
db2 -v alter tablespace M_inv_SPACE prefetchsize 8M
db2 -v alter tablespace M_inv_idx_SPACE prefetchsize 8M
db2 -v alter tablespace o_cust_SPACE prefetchsize 8M
db2 -v alter tablespace o_ords_SPACE prefetchsize 8M
db2 -v alter tablespace o_ords_idx_SPACE prefetchsize 8M
db2 -v alter tablespace o_ordl_SPACE prefetchsize 8M
db2 -v alter tablespace o_item_SPACE prefetchsize 8M
db2 -v alter tablespace o_item_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_comp_SPACE prefetchsize 8M
db2 -v alter tablespace s_comp_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_sc_SPACE prefetchsize 8M
db2 -v alter tablespace s_sc_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_pol_SPACE prefetchsize 8M
db2 -v alter tablespace s_pol_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_po_SPACE prefetchsize 8M
db2 -v alter tablespace s_po_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_site_SPACE prefetchsize 8M
db2 -v alter tablespace s_site_idx_SPACE prefetchsize 8M
db2 -v alter tablespace s_supp_SPACE prefetchsize 8M
db2 -v alter tablespace s_supp_idx_SPACE prefetchsize 8M
db2 -v connect to specdb
db2 -v alter bufferpool C_cust_bp immediate size 7514368
db2 -v alter bufferpool C_c_idx_bp immediate size 528896
db2 -v alter bufferpool C_supp_bp immediate size 1280
db2 -v alter bufferpool C_supp_idx_bp immediate size 1280
db2 -v alter bufferpool C_site_bp immediate size 1280
db2 -v alter bufferpool C_site_idx_bp immediate size 1280
db2 -v alter bufferpool C_parts_bp immediate size 976384
db2 -v alter bufferpool C_p_idx_bp immediate size 488704
db2 -v alter bufferpool C_ci_bp immediate size 14810880
db2 -v alter bufferpool C_ci_idx_bp immediate size 11135744 
db2 -v alter bufferpool M_parts_bp immediate size 5744224
db2 -v alter bufferpool M_parts_idx_bp immediate size 5524992 
db2 -v alter bufferpool M_bom_bp immediate size 760320 
db2 -v alter bufferpool M_bom_idx_bp immediate size 410112 
db2 -v alter bufferpool M_wo_bp immediate size 511488
db2 -v alter bufferpool M_wo_idx_bp immediate size 262144
db2 -v alter bufferpool M_lo_bp immediate size 76800
db2 -v alter bufferpool M_lo_idx_bp immediate size 76800
db2 -v alter bufferpool M_inv_bp immediate size 394240 
db2 -v alter bufferpool M_inv_idx_bp immediate size 318464 
db2 -v alter bufferpool O_cust_bp immediate size 1280
db2 -v alter bufferpool O_ords_bp immediate size 249600
db2 -v alter bufferpool O_ords_idx_bp immediate size 355222
db2 -v alter bufferpool O_ordl_bp immediate size 881664
db2 -v alter bufferpool O_ordl_idx_bp immediate size 594432
db2 -v alter bufferpool O_item_bp immediate size 62464 
db2 -v alter bufferpool O_item_idx_bp immediate size 38400 
db2 -v alter bufferpool S_comp_bp immediate size 768256 
db2 -v alter bufferpool S_comp_idx_bp immediate size 205056 
db2 -v alter bufferpool S_sc_bp immediate size 2859264 
db2 -v alter bufferpool S_sc_idx_bp immediate size 3265024 
db2 -v alter bufferpool S_po_bp immediate size 24064
db2 -v alter bufferpool S_pol_bp immediate size 64000 
db2 -v alter bufferpool S_po_idx_bp immediate size 29440
db2 -v alter bufferpool S_pol_idx_bp immediate size 53248
db2 -v alter bufferpool S_site_bp immediate size 1280
db2 -v alter bufferpool S_site_idx_bp immediate size 1280
db2 -v alter bufferpool S_supp_bp immediate size 1280
db2 -v alter bufferpool S_supp_idx_bp immediate size 1280
db2 -v alter bufferpool U_bp immediate size 1280
db2 -v alter bufferpool U_idx_bp immediate size 1280
db2 -v alter bufferpool ibmdefaultbp immediate size 639864
db2 -v terminate
db2stop
dd if=/dev/zero of=/dev/rloglv bs=4096k count=21
db2start
