1、用戶可以通過(guò)DB2的工具創(chuàng)建數(shù)據(jù)庫(kù)
2、創(chuàng)建緩沖層 一般建三個(gè)32K頁(yè)的緩沖池
3、創(chuàng)建三個(gè)表空間,系統(tǒng)表空間、用戶表空間、常規(guī)表空間,這三個(gè)表空間分別使用剛才創(chuàng)建的緩沖池
4、創(chuàng)建數(shù)據(jù)庫(kù)表
(1)無(wú)主鍵
create table helpDoConfg
(
ID INTEGER ,
IP VARCHAR(16),
PORT VARCHAR(8),
projectName VARCHAR(16)
) in webwfuserspace;
(2)主鍵自增長(zhǎng)但不控制起點(diǎn)
create table helpDoConfg
(
ID INTEGER not null generated as identity,
IP VARCHAR(16),
PORT VARCHAR(8),
projectName VARCHAR(16)
) in webwfuserspace;
(3)主鍵自增長(zhǎng)控制起點(diǎn)
create table helpDoConfg
(
ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 20000, INCREMENT BY 1, CACHE 20, NO CYCLE,
NO ORDER),
IP VARCHAR(16),
PORT VARCHAR(8),
projectName VARCHAR(16)
) in webwfuserspace;