创建db2表空间 - 360文档中心

合集下载

相关主题

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

CREATE TABLESPACE AUDIT_TBS
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_TBS' 3G
)
EXTENTSIZE 4
BUFFERPOOL AUDIT_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TABLESPACE AUDIT_IND
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_IND' 1G
)
EXTENTSIZE 4
BUFFERPOOL AUDIT_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TABLESPACE AUDIT_DAP
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_DAP' 3G
)
EXTENTSIZE 4
BUFFERPOOL DATA_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TABLESPACE AUDIT_DAP_IND
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_DAP_IND' 1G
)
EXTENTSIZE 4
BUFFERPOOL DATA_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TABLESPACE AUDIT_DATA
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_DATA' 3G
)
EXTENTSIZE 4
BUFFERPOOL DATA_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TABLESPACE AUDIT_DATA_IND
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32K
MANAGED BY DATABASE
USING
(File 'E:\DB2\database\AUDIT_DATA_IND' 1G
)
EXTENTSIZE 4
BUFFERPOOL DATA_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TEMPORARY TABLESPACE AUDIT_TEMP
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 32768
MANAGED BY DATABASE
USING
( file 'E:\DB2\database\AUDIT_TEMP' 1G
)
EXTENTSIZE 4
BUFFERPOOL TEMP_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;

CREATE TEMPORARY TABLESPACE AUDIT_TEMP
IN DATABASE PARTITION GROUP IBMTEMPGROUP
PAGESIZE 32K
MANAGED BY SYSTEM
USING
('E:\DB2\database\AUDIT_TEMP.TMP'
)
EXTENTSIZE 32
BUFFERPOOL TEMP_BUF_POOL
OVERHEAD 7.50
TRANSFERRATE 0.06
DROPPED TABLE RECOVERY OFF;