DB2 Version 9.7 for Linux, UNIX, and Windows

Configuring a database to accommodate spatial data

This topic identifies the DB2® configuration parameters that influence the operations of DB2 Spatial Extender.

Before you begin

About this task

DB2 Spatial Extender, which runs in the DB2 database environment, works with most default DB2 configuration values. However, several configuration parameters affect spatial operations. You must tune these parameters so that your spatial applications perform as efficiently as possible. When you modify the values of these parameters for a database, the change affects only that database. In certain cases, choosing a value other than the default value is required for spatial operations. In other cases, doing so is recommended, depending on your applications and your overall DB2 environment.

The following sections explain how to tune the DB2 database manager and database configuration parameters that affect DB2 Spatial Extender operations.