Arcsde+9.3+db2+安装简单图解

Arcsde 9.3 db2 安装简单图解

Benjz

（最近到新的公司DB2一直没有接触过一切从头开始）

在IBM网站下载db2 以及对应的spatial extender

https://www.wendangku.net/doc/7a727917.html,/support/docview.wss?rs=71&uid=swg21256059

先后安装上述软件

确保安装目录下空间扩展dll存在

准备sql语句如下

FORCE APPLICATION ALL;

DB2STOP;

DB2START;

DROP DATABASE arcsde;

FORCE APPLICATION ALL;

DB2STOP;

DB2START;

CREATE DATABASE arcsde USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM USER TABLESPACE MANAGED BY DATABASE USING (FILE 'd:\db2\arcsde\sde.tbsp' 51200) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 24.1 TRANSFERRATE 0.9;

CONNECT TO arcsde user db2admin using bjz;

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

CREATE REGULAR TABLESPACE idxtbs PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE

'd:\db2\arcsde\idxtbs' 51200) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9;

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

CREATE USER TEMPORARY TABLESPACE sdespace PAGESIZE 4 K MANAGED BY SYSTEM USING ('d:\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;

FORCE APPLICATION ALL;

DB2STOP FORCE;

DB2START;

执行

刷新数据库如下

启用空间扩展

如下

环境准备完毕Postinstall sde

successful

successful

Ok