1、創(chuàng)建數(shù)據(jù)庫(kù)
CREATE DATABASE frk
AUTOMATIC STORAGE NO ON
'C:\' USING CODESET UTF-8 TERRITORY CN COLLATE
USING SYSTEM PAGESIZE 32768
CATALOG TABLESPACE MANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksysdectablespace' 51200 )
USER TABLESPACE MANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksysusertablespace' 51200 )
TEMPORARY TABLESPACE MANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksystemptablespace' 51200 ) ;
2、創(chuàng)建緩沖池
CONNECT TO FRK;
CREATE BUFFERPOOL BUFFER1 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER2 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER3 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER4 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
CONNECT RESET;
3、創(chuàng)建表空間
CONNECT TO FRK;
CREATE REGULAR TABLESPACE FRKREGTABLESPACE PAGESIZE 32 K MANAGED BY DATABASE USING ( FILE 'E:\db2 data\frkregtablespacedata' 16000 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL BUFFER1 DROPPED TABLE RECOVERY ON;
CREATE SYSTEM TEMPORARY TABLESPACE FRKSYSTEMPTSPACE PAGESIZE 32 K MANAGED BY DATABASE USING ( FILE 'E:\db2 data\frmsystemtablespacedata' 6400 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL BUFFER2 ;
CREATE USER TEMPORARY TABLESPACE FRKUSERTEMPTSPACE PAGESIZE 32 K MANAGED BY DATABASE USING ( FILE 'E:\db2 data\frkusertemptablespacedata' 6400 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL BUFFER3 ;
CREATE LARGE TABLESPACE FRKLAGGERTSPACE PAGESIZE 32 K MANAGED BY DATABASE USING ( FILE 'E:\db2 data\frkloggertablespacedata' 16000 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL BUFFER4 ;
CONNECT RESET;
4、創(chuàng)建表
CREATE TABLE abc(
id integer NOT NULL ,
name VARCHAR(180))
IN FRKREGTABLESPACE;