DB2 创建数据库缓冲池和表空间
1、创建数据库CREATE DATABASE frk
AUTOMATIC STORAGE NOON
'C:\' USING CODESET UTF-8 TERRITORY CN COLLATE
USING SYSTEM PAGESIZE 32768
CATALOG TABLESPACEMANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksysdectablespace' 51200 )
USER TABLESPACEMANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksysusertablespace' 51200 )
TEMPORARY TABLESPACEMANAGED BY DATABASE
USING ( FILE 'E:\db2 data\frksystemptablespace' 51200 ) ;
2、创建缓冲池
CONNECT TO FRK;
CREATE BUFFERPOOL BUFFER1 IMMEDIATESIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER2 IMMEDIATESIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER3 IMMEDIATESIZE 250 PAGESIZE 32 K ;
CREATE BUFFERPOOL BUFFER4 IMMEDIATESIZE 250 PAGESIZE 32 K ;
CONNECT RESET;
3、创建表空间
CONNECT TO FRK;
CREATEREGULARTABLESPACE FRKREGTABLESPACE PAGESIZE 32 KMANAGED BY DATABASEUSING ( FILE 'E:\db2 data\frkregtablespacedata' 16000 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOLBUFFER1DROPPED TABLE RECOVERY ON;
CREATESYSTEM TEMPORARYTABLESPACE FRKSYSTEMPTSPACE PAGESIZE 32 KMANAGED BY DATABASEUSING ( FILE 'E:\db2 data\frmsystemtablespacedata' 6400 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOLBUFFER2 ;
CREATEUSER TEMPORARYTABLESPACE FRKUSERTEMPTSPACE PAGESIZE 32 KMANAGED BY DATABASEUSING ( FILE 'E:\db2 data\frkusertemptablespacedata' 6400 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOLBUFFER3 ;
CREATELARGETABLESPACE FRKLAGGERTSPACE PAGESIZE 32 KMANAGED BY DATABASEUSING ( FILE 'E:\db2 data\frkloggertablespacedata' 16000 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOLBUFFER4 ;
CONNECT RESET;
4、创建表
CREATE TABLE abc(
id integer NOT NULL ,
name VARCHAR(180))
IN FRKREGTABLESPACE;
页:
[1]