
db2 -v connect to specdb

# Bufferpool takes into account storage growth rate
db2 -v alter bufferpool C_cust_bp immediate size 3757824
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 488704
db2 -v alter bufferpool C_p_idx_bp immediate size 488704
db2 -v alter bufferpool C_ci_bp immediate size 8594432
db2 -v alter bufferpool C_ci_idx_bp immediate size 8553472
db2 -v alter bufferpool M_parts_bp immediate size 5744224
db2 -v alter bufferpool M_parts_idx_bp immediate size 192000
db2 -v alter bufferpool M_bom_bp immediate size 380672
db2 -v alter bufferpool M_bom_idx_bp immediate size 232704
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 197632
db2 -v alter bufferpool M_inv_idx_bp immediate size 153088
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 31232
db2 -v alter bufferpool O_item_idx_bp immediate size 19200
db2 -v alter bufferpool S_comp_bp immediate size 384768
db2 -v alter bufferpool S_comp_idx_bp immediate size 117504
db2 -v alter bufferpool S_sc_bp immediate size 1430016
db2 -v alter bufferpool S_sc_idx_bp immediate size 1576704
db2 -v alter bufferpool S_po_bp immediate size 24064
db2 -v alter bufferpool S_pol_bp immediate size 114688
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 319932

db2 -v terminate
