【DB2数据库创建分区表】

创建表空间

CREATE TABLESPACE DMS01

 

CREATE TABLESPACE dms02

 

CREATE TABLESPACE dms03

 

创建表

CREATE TABLE artists

(

artno SMALLINT NOT NULL PRIMARY KEY,

name VARCHAR(50),

picture BLOB(2M) NOT LOGGED COMPACT

)

IN dms01

INDEX IN dms02

LONG  IN dms03

 

CREATE INDEX idx_name ON artists (name)

 

分区表的使用

定义区间

CREATE TABLE sales(sale_date DATE, customer INT) 

PARTITION BY RANGE(sale_date)

(    

STARTING '1/1/2000'  ENDING '3/31/2000',    

STARTING '4/1/2000'  ENDING '6/30/2000',</