2012.7.30
1、创建ods表空间
CONNECT TO DB_HB;
CREATE  REGULAR  TABLESPACE TBS_ODS PAGESIZE 4 K  MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 64 OVERHEAD 10.5 PREFETCHSIZE 64 TRANSFERRATE 0.14 BUFFERPOOL  IBMDEFAULTBP  DROPPED TABLE RECOVERY ON;
COMMENT ON TABLESPACE TBS_ODS IS 'ods表空间';
CONNECT RESET;

create table hb_ods.t_ods(id int not null primary key, c1 char(20));
INSERT INTO hb_ods.t_ods VALUES(1,'mkdx');
INSERT INTO hb_ods.t_ods VALUES(2,'cmmmkkk');
INSERT INTO hb_ods.t_ods VALUES(3,'ooddsss');
SELECT * FROM hb_ods.t_ods;

create table hb_dw.t_dw(id int not null primary key, c1 char(20));
INSERT INTO hb_dw.t_dw VALUES(1,'sadfas');
INSERT INTO hb_dw.t_dw VALUES(2,'2222');
SELECT * FROM hb_dw.t_dw;

create table hb_mk.t_mk(id int not null primary key, c1 char(20));
INSERT INTO hb_mk.t_mk VALUES(1,'mkdx');
INSERT INTO hb_mk.t_mk VALUES(2,'cmmmkkk');
SELECT * FROM hb_mk.t_mk;

2、创建表空间
db2 create tablespace mytbsp1
表结构
db2 create  table test1(col1 int, col2 char(20)) in mytbsp1
索引
db2 create index idx1 on test1(col1)

3、查看表空间下面有多少个表
SELECT TABNAME FROM SYSCAT.TABLES WHERE TBSPACE='TBS_ODS' 

4、创建、删除实例，安装db2时，系统会自动创建一个默认的实例DB2
db2icrt inst1
db2idrop