阅读:2119回复:0
DB2环境下安装arcsde的脚本
<br>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;<br>--创建了200M的空间,pagesize4k</p> <p>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;</p> <p>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;</p> <p>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; </p> <p>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";</p> <p>GRANT USE OF TABLESPACE regtbs TO PUBLIC WITH GRANT OPTION;</p> <p>GRANT USE OF TABLESPACE idxtbs TO PUBLIC WITH GRANT OPTION;</p> <p>GRANT USE OF TABLESPACE lobtbs TO PUBLIC WITH GRANT OPTION;</p> <p>GRANT USE OF TABLESPACE sdespace TO PUBLIC WITH GRANT OPTION;</p> <p>COMMENT ON TABLESPACE sdespace IS '';</p> <p>GRANT DBADM ON DATABASE TO USER SDE;</p> <p>UPDATE DATABASE CONFIGURATION FOR arcsde USING APP_CTL_HEAP_SZ 2048;</p> <p>UPDATE DATABASE CONFIGURATION FOR arcsde USING APPLHEAPSZ 2048;</p> <p>UPDATE DATABASE CONFIGURATION FOR arcsde USING LOGFILSIZ 1000;</p> <p>UPDATE DATABASE CONFIGURATION FOR arcsde USING LOGPRIMARY 10;</p> |
|