通过以下语句建表空间的 drop tablespace TBS_IDX4K; CREATE REGULAR TABLESPACE TBS_IDX4K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (device '/dev/mapper/data_vg-db2_idx01'50M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON; drop tablespace TBS_LOB1; CREATE LARGE TABLESPACE TBS_LOB1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '/db2_large/tbs_lob1.dat'6000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF32K OVERHEAD 12.670000 TRANSFERRATE 0.180000; drop tablespace TBS_LOB2; CREATE LARGE TABLESPACE TBS_LOB2 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '/db2_large/tbs_lob2.dat'6000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF32K OVERHEAD 12.670000 TRANSFERRATE 0.180000;
drop tablespace TBS_8K; CREATE REGULAR TABLESPACE TBS_8K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (device '/dev/mapper/data_vg-db2_dta02'100M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON;
CREATE SYSTEM TEMPORARY TABLESPACE TBS_systmp IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING ('/db2_systmp') EXTENTSIZE 8 BUFFERPOOL IBMDEFAULTBP; DROP TABLESPACE TEMPSPACE1;
DROP TABLESPACE TBS_IDX_CISA_E, TBS_TABLE_CISA_E;
CREATE REGULAR TABLESPACE TBS_TABLE_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (device '/dev/mapper/data_vg-db2_jf_dta01'500M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON;
CREATE REGULAR TABLESPACE TBS_IDX_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (device '/dev/mapper/data_vg-db2_jf_idx01'250M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON;
drop tablespace userspace1;
CREATE REGULAR TABLESPACE USERSPACE1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (device '/dev/mapper/data_vg-db2_dta01'1000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON;