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>