用友NC57创建db2数据库环境

--建数据库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 RESETconnect to NCXH user db2inst1 using db2inst1 CREATE Bufferpool NCUSED4 SIZE 102400 PAGESIZE 4KCREATE Bufferpool NCUSED16 SIZE 38400 PAGESIZE 16KCREATE Bufferpool NCUSED16 SIZE 38400 PAGESIZE 16KCREATE 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 NCUSED16CREATE 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 NCUSED4CREATE 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 db2inst1GRANT USE OF TABLESPACE NNC_DATA01 TO USER db2inst1 WITH GRANT OPTIONGRANT USE OF TABLESPACE NNC_INDEX01 TO USER db2inst1 WITH GRANT OPTIONGRANT USE OF TABLESPACE USERTEMP TO USER db2inst1 WITH GRANT OPTION