Verifying the Spatial Extender installation

After installing Db2® Spatial Extender you should validate the installation.

Before you begin

The following prerequisites must be completed before you can validate a Db2 Spatial Extender installation:

Db2 Spatial Extender must be installed on a computer.
A Db2 instance must have been created on the computer where the Db2 data server is installed.

About this task

This task is one that should be performed following the task of setting up and configuring Db2 Spatial Extender. For more information, seeSetting up and installing Db2 Spatial Extender. The task comprises of creating a Db2 database and running a Db2 Spatial Extender sample application. This test is sufficient to validate that Db2 Spatial Extender has been installed and configured correctly.

Procedure

To verify the Db2 Spatial Extender installation:

Linux® and UNIX: Log on to the system with the user ID that corresponds to the Db2 instance owner role.
Create a Db2 database.
To do this, open a Db2 Command Window and enter the following:
```
db2 create database mydb
```
where mydb is the database name.
Ensure that you have a system temporary table space with a page size of 8 KB or larger and with a minimum size of 500 pages.
If you do not have such a table space, see Creating temporary table spaces for details on how to create it. This is a requirement to run the runGSEdemo program.
For Windows operating systems, set the agent_stack_sz database manager configuration parameter to a value of 100 or larger. The following example shows the CLP command to set the parameter to 110:
```
UPDATE DBM CFG USING AGENT_STACK_SZ 110
```
Go to the directory where the runGSEdemo program resides:
- For Db2 Spatial Extender installations on Linux and UNIX operating systems, enter:
```
cd $HOME/sqllib/samples/extenders/spatial
```
  where $HOME is the instance owner's home directory.
- For Db2 Spatial Extender installation on Windows operating systems, enter:
```
cd c:\Program Files\IBM\sqllib\samples\extenders\spatial
```
  where c:\Program Files\IBM\sqllib is the directory in which you installed Db2 Spatial Extender.
Run the installation check program.
At the Db2 command line, enter the runGseDemo command:
```
runGseDemo mydb userID password
```
where mydb is the database name.