在生产环境中有如下表空间,现在只有 TEMPSPACE8K 有自己的文件系统,其他临时表空间都挂载在/db/a3ineccp/db2data/eccppr 文件系统下,导致了文件系统满问题。
现在想通过新建文件系统,在新建相应的tempspace,想问,新产生的临时数据会选择新建的tempspace吗? 还有能不能删除掉造成文件系统满的tempspace?
CREATE TEMPORARY TABLESPACE "TEMPSPACE2" IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('/db/a3ineccp/db2data/eccppr/tempspace2')
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL BP8KTMP
OVERHEAD 10.500000
TRANSFERRATE 0.140000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
CREATE TEMPORARY TABLESPACE "TEMPSPACE3" IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM
USING ('/db/a3ineccp/db2data/eccppr/tempspace3')
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL LONGTMPBUFFER
OVERHEAD 10.500000
TRANSFERRATE 0.140000
NO FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
CREATE TEMPORARY TABLESPACE "TEMPSPACE8K" IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('/db/a3ineccp/db2data/tempspace')
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL TT8KBUFFER
OVERHEAD 12.670000
TRANSFERRATE 0.180000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
收起