【IT168 技术】1、创建数据库
1 CREATE DATABASE frk
2 AUTOMATIC STORAGE NO ON
3 'C:\' USING CODESET UTF-8 TERRITORY CN COLLATE
4 USING SYSTEM PAGESIZE 32768
5 CATALOG TABLESPACE MANAGED BY DATABASE
6 USING ( FILE 'E:\db2 data\frksysdectablespace' 51200 )
7 USER TABLESPACE MANAGED BY DATABASE
8 USING ( FILE 'E:\db2 data\frksysusertablespace' 51200 )
9 TEMPORARY TABLESPACE MANAGED BY DATABASE
10 USING ( FILE 'E:\db2 data\frksystemptablespace' 51200 ) ;
2 AUTOMATIC STORAGE NO ON
3 'C:\' USING CODESET UTF-8 TERRITORY CN COLLATE
4 USING SYSTEM PAGESIZE 32768
5 CATALOG TABLESPACE MANAGED BY DATABASE
6 USING ( FILE 'E:\db2 data\frksysdectablespace' 51200 )
7 USER TABLESPACE MANAGED BY DATABASE
8 USING ( FILE 'E:\db2 data\frksysusertablespace' 51200 )
9 TEMPORARY TABLESPACE MANAGED BY DATABASE
10 USING ( FILE 'E:\db2 data\frksystemptablespace' 51200 ) ;
2、创建缓冲池
1 CONNECT TO FRK;
2 CREATE BUFFERPOOL BUFFER1 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
3 CREATE BUFFERPOOL BUFFER2 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
4 CREATE BUFFERPOOL BUFFER3 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
5 CREATE BUFFERPOOL BUFFER4 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
6 CONNECT RESET;
2 CREATE BUFFERPOOL BUFFER1 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
3 CREATE BUFFERPOOL BUFFER2 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
4 CREATE BUFFERPOOL BUFFER3 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
5 CREATE BUFFERPOOL BUFFER4 IMMEDIATE SIZE 250 PAGESIZE 32 K ;
6 CONNECT RESET;
3、创建表空间
1 CONNECT TO FRK;
2 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;
3 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 ;
4 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 ;
5 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 ;
6 CONNECT RESET;
7
2 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;
3 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 ;
4 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 ;
5 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 ;
6 CONNECT RESET;
7
4、创建表
1 CREATE TABLE abc(
2 id integer NOT NULL ,
3 name VARCHAR(180))
4 IN FRKREGTABLESPACE;
2 id integer NOT NULL ,
3 name VARCHAR(180))
4 IN FRKREGTABLESPACE;
查看原文:http://www.blogjava.net/sxyx2008/archive/2010/06/27/324583.html