--缓冲池

CREATE BUFFERPOOL EMP_BUF_POOL  
IMMEDIATE  ALL DBPARTITIONNUMS  
SIZE 250  
NUMBLOCKPAGES 0  
PAGESIZE 32 K;

--临时表空间

CREATE TEMPORARY TABLESPACE EMP_TMP  
IN DATABASE PARTITION GROUP IBMTEMPGROUP  
PAGESIZE 32K  
MANAGED BY DATABASE   
USING   (File ‘/home/db2inst1/db2inst1/NODE0000/NG2_APP8/T0000000/EMP_TMP/hefei.dat‘ 2G   )  
EXTENTSIZE 32  
PREFETCHSIZE AUTOMATIC  BUFFERPOOL EMP_BUF_POOL  
OVERHEAD 7.50  
TRANSFERRATE 0.06  
DROPPED TABLE RECOVERY OFF;

--物理表空间
CREATE REGULAR TABLESPACE TBS_EMP  
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP  
PAGESIZE 32K  
MANAGED BY DATABASE   
USING   (File ‘/home/db2inst1/db2inst1/NODE0000/NG2_APP8/T0000000/TBS_EMP‘ 2G       )  EXTENTSIZE 32  
PREFETCHSIZE AUTOMATIC  BUFFERPOOL EMP_BUF_POOL  
OVERHEAD 7.50  
TRANSFERRATE 0.06  
DROPPED TABLE RECOVERY ON;

db2建立表空间