CONNECT TO SPECDB;
CREATE BUFFERPOOL SPEC_BP PAGESIZE 4K;
CREATE BUFFERPOOL JMS_BP PAGESIZE 32K;
CREATE BUFFERPOOL M_INV_BP PAGESIZE 4K;
CREATE TABLESPACE M_INV_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_INV_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL M_PARTS_BP PAGESIZE 4K;
CREATE TABLESPACE M_PARTS_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_PARTS_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL M_BOM_BP PAGESIZE 4K;
CREATE TABLESPACE M_BOM_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_BOM_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL M_WO_BP PAGESIZE 4K;
CREATE TABLESPACE M_WO_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_WO_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL M_WO2_BP PAGESIZE 4K;
CREATE TABLESPACE M_WO2_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_WO2_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL M_OL_BP PAGESIZE 4K;
CREATE TABLESPACE M_OL_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL M_OL_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_O_BP PAGESIZE 4K;
CREATE TABLESPACE O_O_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_O_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_O2_BP PAGESIZE 4K;
CREATE TABLESPACE O_O2_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_O2_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_OL_BP PAGESIZE 4K;
CREATE TABLESPACE O_OL_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_OL_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_CI_BP PAGESIZE 4K;
CREATE TABLESPACE O_CI_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_CI_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_C_BP PAGESIZE 4K;
CREATE TABLESPACE O_C_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_C_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_ITEM_BP PAGESIZE 4K;
CREATE TABLESPACE O_ITEM_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_ITEM_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL O_ITEM2_BP PAGESIZE 4K;
CREATE TABLESPACE O_ITEM2_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL O_ITEM2_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_C_BP PAGESIZE 4K;
CREATE TABLESPACE S_C_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_C_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_S_C_BP PAGESIZE 4K;
CREATE TABLESPACE S_S_C_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_S_C_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_S_BP PAGESIZE 4K;
CREATE TABLESPACE S_S_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_S_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_P_O_BP PAGESIZE 4K;
CREATE TABLESPACE S_P_O_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_P_O_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_P_O2_BP PAGESIZE 4K;
CREATE TABLESPACE S_P_O2_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_P_O2_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE BUFFERPOOL S_P_OL_BP PAGESIZE 4K;
CREATE TABLESPACE S_P_OL_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL S_P_OL_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE S_R_CONFIG_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE U_SEQ_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE U_DS_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE U_L_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE U_L_M_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE U_L_S_SPACE PAGESIZE 4K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL SPEC_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
CREATE TABLESPACE JMS_SPACE PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL JMS_BP INITIALSIZE 500M EXTENTSIZE 1024K PREFETCHSIZE 8K;
