CREATE DATABASE arcsde USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM USER TABLESPACE MANAGED BY DATABASE USING (FILE 'e:\data\db2\sde.tbsp' 51200) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 24.1 TRANSFERRATE 0.9;
--创建了200M的空间,pagesize4k

CREATE REGULAR TABLESPACE regtbs PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'e:\data\db2\regtbs' 10240) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9;

CREATE REGULAR TABLESPACE idxtbs PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'e:\data\db2\idxtbs' 5120) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9;

CREATE LONG TABLESPACE lobtbs PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'e:\data\db2\lobtbs' 5120) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9;

CREATE USER TEMPORARY TABLESPACE sdespace PAGESIZE 4 K MANAGED BY SYSTEM USING ( 'e:\data\db2\sdespace' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL "IBMDEFAULTBP";

GRANT USE OF TABLESPACE regtbs TO PUBLIC WITH GRANT OPTION;

GRANT USE OF TABLESPACE idxtbs TO PUBLIC WITH GRANT OPTION;

GRANT USE OF TABLESPACE lobtbs TO PUBLIC WITH GRANT OPTION;

GRANT USE OF TABLESPACE sdespace TO PUBLIC WITH GRANT OPTION;

COMMENT ON TABLESPACE sdespace IS '';

GRANT DBADM ON DATABASE TO USER SDE;

UPDATE DATABASE CONFIGURATION FOR arcsde USING APP_CTL_HEAP_SZ 2048;

UPDATE DATABASE CONFIGURATION FOR arcsde USING APPLHEAPSZ 2048;

UPDATE DATABASE CONFIGURATION FOR arcsde USING LOGFILSIZ 1000;

UPDATE DATABASE CONFIGURATION FOR arcsde USING LOGPRIMARY 10;