Setting up and installing spatial support
A spatial support system consists of a Db2® database system, IBM® Spatial Support for Db2 for z/OS®, and, for most applications, a map viewer.
Before you begin
Before you set up IBM Spatial Support for Db2 for z/OS,
you must have the following software installed:
- You must have Db2 11 for z/OS installed and operating in new-function mode.
- You must have the Db2 Open Database Connectivity (ODBC) feature for Db2 11 for z/OS installed and configured.
- To access spatial data from a remote client application, you must install the version of DB2 Connect that is required for Db2 11 for z/OS. For more information, see the Program Directory for the Db2 Accessories Suite.
About this task
A map viewer is not required but is useful for visually rendering the results of spatial queries, generally in the form of maps. An example of an easy-to-use map viewer is ArcMap, which is included as an application for ArcGIS and developed by ESRI. Open source map viewers are also available.
Databases enabled for spatial support are located on the server. You can use client applications to access spatial data through the IBM Spatial Support for Db2 for z/OS stored procedures and spatial queries.
Procedure
To install and set up spatial support:
- Ensure that your system meets all of the system requirements.
- Install IBM Spatial Support for Db2 for z/OS.
Ensure that you have the Program Directory for the Db2 Accessories Suite and the IBM Spatial Support for Db2 for z/OS product tape. The program directory provides instructions for the SMP/E installation and includes the correct service levels for all of the required software.
- Verify the installation by issuing two SQL statements.
-
If necessary, see the troubleshooting tips in Identifying IBM Spatial Support for Db2 for z/OS problems and take
appropriate actions to correct any problems.
To access Db2 documentation, go to the Db2 collection in the IBM Knowledge Center at the following website: http://www-01.ibm.com/support/knowledgecenter/SSEPEK/db2z_prodhome.html. This collection contains documentation for the Db2 database system and related products.