db2创建表空间运行执行计划表步骤

查看表空间位置

db2 connect to sample----连数据库

db2 list tablespaces

Database Connection Information

Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

[db2inst1@107-sqlcheck ~]$ db2 list tablespaces

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal

list tablespace containers for tablespaceID（表空间id号） show detail

list tablespace containers for 0 show detail

[db2inst1@107-sqlcheck ~]$ db2 list tablespace containers for 0 show detail

Tablespace Containers for Tablespace 0

Container ID = 0
Name = /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000000/C0000000.CAT
Type = File
Total pages = 20480
Useable pages = 20476
Accessible = Yes

创建buffer pool
db2 create BUFFERPOOL bigbuffer SIZE 4000 PAGESIZE 32K（可取数4k,8K,16K)

创建表空间
db2 "create tablespace newtbs04 pagesize 32k managed by system using ('/home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000001/test.TMP') BUFFERPOOL bigbuffer "

newtbs04----代表表空间名
pagesize 32k 32可以指定为8k 16k 32k
bigbuffer---代表表空间名

授权
db2 grant use of tablespace newtbs04 to user db2dpmon

修改表EXPLAIN.DDL文件