用友NC57创建db2数据库环境

最新推荐文章于 2017-03-09 20:57:50 发布

原创最新推荐文章于 2017-03-09 20:57:50 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

nc57 同时被 2 个专栏收录

35 篇文章

订阅专栏

db2

4 篇文章

订阅专栏

本文详细介绍了如何创建数据库并配置缓冲池、表空间等关键组件，包括使用特定目录存储数据和元数据，设置不同的缓冲池大小，以及为用户分配相应的表空间权限。

--建数据库
CREATE DATABASE NCXH USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM CATALOG TABLESPACE   MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Catalogdata1' 128000 ) USER TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Userdata1' 512000 ) TEMPORARY TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Tempspace1' 768000 )

 
CREATE DATABASE NCXH USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM CATALOG TABLESPACE   MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Catalogdata1' 128000 ) USER TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Userdata1' 512000 ) TEMPORARY TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\Tempspace1' 768000 ) 
CONNECT RESET
connect to NCXH user db2inst1 using db2inst1 
CREATE Bufferpool NCUSED4 SIZE 102400 PAGESIZE 4K
CREATE Bufferpool NCUSED16 SIZE 38400 PAGESIZE 16K
CREATE Bufferpool NCUSED16 SIZE 38400 PAGESIZE 16K
CREATE REGULAR TABLESPACE NNC_DATA01 PAGESIZE 16K MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\nnc_data01' 204800) EXTENTSIZE 8 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL NCUSED16
CREATE REGULAR TABLESPACE NNC_INDEX01 PAGESIZE 4K MANAGED BY DATABASE USING ( FILE 'C:\DBBAK\nnc_index01' 204800) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL NCUSED4
CREATE USER TEMPORARY TABLESPACE USERTEMP PAGESIZE 16 K MANAGED BY SYSTEM USING ( 'C:\DBBAK\Usertemp1' ) EXTENTSIZE 32 OVERHEAD 10.67 PREFETCHSIZE 32 TRANSFERRATE 0.04 BUFFERPOOL   NCUSED16 

CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE2 PAGESIZE 16 K MANAGED BY SYSTEM USING ( 'C:\DBBAK\Tempspace2' ) EXTENTSIZE 32 OVERHEAD 10.67 PREFETCHSIZE 32 TRANSFERRATE 0.04 BUFFERPOOL   NCUSED16 

GRANT  DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE  TO USER DB2INST1;
GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE  TO USER db2inst1
GRANT USE OF TABLESPACE NNC_DATA01 TO USER db2inst1 WITH GRANT OPTION
GRANT USE OF TABLESPACE NNC_INDEX01 TO USER db2inst1 WITH GRANT OPTION
GRANT USE OF TABLESPACE USERTEMP TO USER db2inst1 WITH GRANT OPTION