DB2 Creating Table Spaces

--Buffer pool

CREATE Bufferpool Emp_buf_pool
IMMEDIATE All Dbpartitionnums
SIZE 250
Numblockpages 0
PAGESIZE K;

--Temporary table space

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;

--Physical table space
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 Creating Table Spaces