用友NC57创建db2数据库环境

最新推荐文章于 2021-01-26 07:13:50 发布

haha_lee

最新推荐文章于 2021-01-26 07:13:50 发布

阅读量1.6k

点赞数 1

分类专栏： nc57 db2

本文链接：https://blog.csdn.net/makeitperfect/article/details/25645743

版权

nc57 同时被 2 个专栏收录

35 篇文章 0 订阅

订阅专栏

db2

4 篇文章 0 订阅

订阅专栏

--建数据库
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