通过以下语句建表空间的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)...
显示全部通过以下语句建表空间的
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;
收起