db2创建表空间

CREATE LARGE TABLESPACE CURR_DATA_TBS01 

  IN DATABASE PARTITION GROUPIBMDEFAULTGROUP

  PAGESIZE 32K

  MANAGED BY DATABASE

  USING ( Device '/dev/ryqrcb_01' 6553600)

  EXTENTSIZE 32

  PREFETCHSIZE AUTOMATIC

  BUFFERPOOL YQRCB_32K

  OVERHEAD 7.5

  TRANSFERRATE 0.06

  AUTORESIZE NO

  NO FILE SYSTEM CACHING

;

CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE1 --创建临时表空间

  IN DATABASE PARTITION GROUPIBMTEMPGROUP

  PAGESIZE 4K

  MANAGED BY AUTOMATIC STORAGE

  EXTENTSIZE 32

  PREFETCHSIZE AUTOMATIC

  BUFFERPOOL IBMDEFAULTBP

  OVERHEAD 7.5

  TRANSFERRATE 0.06