project

Creating Tablespaces and Tables in DB2

BCIS 4620

z

Architecture

Databases have tablespaces

Tablespaces have tables

Tables have key indexes

z

Create a TableSpace

--CREATE TABLESPACES

CREATE TABLESPACE P###TSXX IN P###DB USING STOGROUP UNTDISK;

COMMIT;

z

Create a Table

--CREATE TESTXX TABLE

CREATE TABLE TESTXX

(COURSE_NO CHAR(6) NOT NULL,

COURSE_NAME VARCHAR(25) NOT NULL,

CREDITS DECIMAL (2,0) NOT NULL,

PRIMARY KEY (COURSE_NO))

IN P###DB.M###TSXX;

COMMIT;

z

Create a PK Index

--CREATE PK INDEX ON TESTXX

CREATE UNIQUE INDEX UNTP###.X1XX

ON UNTP###.TESTXX (COURSE_NO)

USING STOGROUP UNTDISK;

COMMIT;

z