Db2 Spatial Extender in a partitioned database environment

The Db2 Spatial Extender can be used effectively in a partitioned database environment to perform spatial analysis against large customer data tables. Partitioned database environments are useful for running data warehousing applications that you can create with the SQL Warehousing Tool (SQW) in the Design Studio.

Partitioned database environments support high-performance and highly scalable database processing by parallel processing across a set of nodes. Each node has its own processor, memory, and disk storage.

In a partitioned database environment, you have three alternatives for storing tables that contain spatial columns. You can place them on a single node, distribute them across multiple nodes or replicate them across multiple nodes. Spatial indexes are supported for each alternative. The alternative that you select depends on the size of the tables and how they will be used in spatial queries. For more information about how to partition a database, see Partitioned database environments..