Issues with DB2 spatial Extender and ARCSDE installed on Windows

Because the customer's DB2 version is version 9.7, the test environment can only install this version, but in the minimum supported version of ARCSDE requires V9.7 Pack 4 version, below this version is not possible.

Installation of DB2 and spatial extender

After installing the DB2 to create a spatial database (if the name is Mysdedb), it is best to optimize the following configuration:

1, note the character encoding when you create the database. 2, it's best to create your own cache pool (using 16 or 32k pagesize). CreateBufferpool Sdepool Size12800pagesize 32KCreateBufferpool sdepool1 Size12800pagesize 32K3, create your own tablespace, and use a custom buffer poolCREATEREGULAR tablespace Regtbs PAGESIZE +K MANAGED by DATABASEUSING (FILE 'C:\DB2\NODE0000\mysdedb\regtbs'20g) Bufferpool SdepoolCREATEREGULAR tablespace Idxtbs PAGESIZE +K MANAGED by DATABASEUSING (FILE 'C:\DB2\NODE0000\mysdedb\idxtbs'10g) Bufferpool SdepoolCREATE LONGTablespace Lobtbs PAGESIZE +K MANAGED by DATABASEUSING (FILE 'C:\DB2\NODE0000\mysdedb\lobtbs'4g) Bufferpool Sdepool1CREATE USER TemporaryTablespace Sdespace PAGESIZE +K MANAGED bySYSTEM USING ('C:\DB2\NODE0000\mysdedb\sdespace') Bufferpool sdepool14, optimize related configurationUpdateDB CFG forMysdedb using Applheapsz2048UpdateDB CFG forMysdedb using APP_CTL_HEAP_SZ2048UpdateDB CFG forMysdedb using LOGPRIMARYTenUpdateDB CFG forMysdedb using LOGFILSIZ +5, create the operating system user SDE, and join the Db2admns user group6, grant the SDE admin mysdedb dba AuthorityGrantDbadm on Database  to UserSde

Install DB2 Spatial Extender, and then enable mysdedb for space extension support

-- You can use the Control Center menu to enable or use the following command db2se enable_db mysdedb

Note: I made a few genius when I enabled the space support, the database was created by SQL to execute, in the Enable this step has been error, and later with the DB2 control center to create a database and enable the error.

To enable an enterprise Geodatabase:

1. Add mysdedb connection configuration in the spatial center of the GIS developer's local DB2:

and add the 10.xx.xx.xx machine name to the host file

2. Add a database connection in the ArcGIS Catalog window

It is theoretically possible to configure the direct connection, but in the latter part of the "Enable Enterprise Geodatabase" will be an error, and by the form of aliases will not

The direct connection configuration is entered in the input box of the data source: hostname=10.10.62.179; Port=50000;database=mysdedb;

3. Run the "Enable Enterprise Geodatabase" tool in Toolbox

Specify the database connection, authorization file created in step 2nd above, and then you can run the tool and, if successful, proceed to the next step.

To install SDE:

My version is SDE 10.1 for DB2

1. Download and install the SDE for DB2.

2. Run the following command:

Sdeservice-OCreate -D DB2,DB2-0 -P123456Sdeservice-o Register-D DB2,DB2-0 -R Admin_database-v Mysdedbsdemon-o Start-P123456

It should be noted here that the DB2 configuration of the-D parameter is not the same as the ArcGIS website, and the official statement is:

"Db2,db2instance" is actually "DB2,DB2 server name" (as you can see in Window's service).

-P parameter is the SDE user's password