Installing the Netezza Spatial Toolkit

Answer

This procedure assumes that you have purchased the Netezza Spatial Toolkit and put the files on the NPS system.

To enable spatial queries:

1. Log in to the NPS system as the nz user.

2. Change to the following location where the spatial library files reside where <ST_version> is the version of the Spatial Toolkit you are installing:

cd /nz/external/iisi/libnetspatial/<ST_version>

 3. Start the installation by specifying the following command where:

<dbname> is the name of the database in which you want to define the spatial functions
<username> is the NPS user account who will own the functions
<password> is the password for the NPS user account

 ./install -d <dbname> -u <username> -W <password>

The command takes about one minute to run and then it displays the message,

Successfully Installed Spatial Library to <dbname>.

Note: If your database name contains spaces or mixed-case letters such as “myDatabase”,

make sure that you specify double-quotation marks around the database name and

escape the quotes. For example:

./install -d \"myDatabase\" -u user -W password