DB2 10.5 for Linux, UNIX, and Windows

Setting up and installing DB2 Spatial Extender

You must set up and install DB2® Spatial Extender to create an environment that supports spatial operations.

Before you begin

Ensure that you meet the installation requirements for DB2 Spatial Extender and DB2 database products. If your system fails to meet any of the software prerequisites, the installation will fail.

About this task

A DB2 Spatial Extender environment consists of a server and a client.

A DB2 Spatial Extender server consists of a DB2 data server installation with the DB2 Spatial Extender software installed.

A DB2 Spatial Extender client consists of an IBM® data server client installation with the DB2 Spatial Extender software that is installed.

Databases that are enabled for spatial operations are in the server. They can be accessed from a client. Spatial data that resides in the databases can be accessed by using DB2 Spatial Extender stored procedures and spatial queries from the server or the client.

Also, generally part of a typical component of a DB2 Spatial Extender environment is a geobrowser. Although they are not required, they are useful to visually render the results of spatial queries, generally in the form of maps. A geobrowser is not included with a DB2 Spatial Extender installation. However, you can obtain the IBM Data Management Geobrowser for DB2 & Informix® to view spatial data.

Procedure

To set up and install DB2 Spatial Extender on a DB2 server or IBM data server client:

Ensure that your system meets all software requirements. Refer to System requirements for installing Spatial Extender.
Install DB2 Spatial Extender by performing one of the following tasks:
For installations using a response file, you must indicate the following keywords for DB2 server installation:
```
INSTALL_TYPE=CUSTOM
COMP=SPATIAL_EXTENDER_CLIENT_SUPPORT
COMP=SPATIAL_EXTENDER_SERVER_SUPPORT
```
You must indicate the following keywords for an IBM data server client installation:
```
INSTALL_TYPE=CUSTOM
COMP=SPATIAL_EXTENDER_CLIENT_SUPPORT
```
You must indicate the following keywords for a DB2 pureScale Feature installation:
```
INSTALL_TYPE = CUSTOM
COMP = PURESCALE
```
Create a DB2 instance if you do not already have one. Use the db2icrt DB2 command from a DB2 command window.
Verify the DB2 Spatial Extender installation was successful by testing the DB2 Spatial Extender environment. Refer to Verifying the Spatial Extender installation.
Optional: Download and install the Data Management Geobrowser. You can download a complimentary copy from https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swg-dm-geobrowser.