1、创建数据库
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、创建缓冲池
CONNECT TO FRK;
CREATE BUFFERPOOL BP_TAB_32K(缓冲池名称) IMMEDIATE SIZE 250 PAGESIZE 32 K(大小) ;
CONNECT RESET;
3、创建表空间并绑定缓冲池
CONNECT TO FRK;
db2 "CREATE LARGE TABLESPACE TBS_DATA_BILL IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32k MANAGED BY AUTOMATIC STORAGE BUFFERPOOL BP_TAB_32K"
4、创建表
CREATE TABLE TABLENAME(
id integer NOT NULL ,
name VARCHAR(180))
IN TBS_DATA_BILL;
DB2 创建数据库,表空间,缓冲池及表语句
最新推荐文章于 2024-06-24 13:53:43 发布