Inventory of resources supplied for your database

To enable a database for spatial support, IBM® Spatial Support for Db2 for z/OS® provides the database with the required resources.

IBM Spatial Support for Db2 for z/OS provides the following resources:
  • Stored procedures. When you request a spatial operation (for example, when you import spatial data), IBM Spatial Support for Db2 for z/OS invokes one of these stored procedures to perform the operation.
  • Spatial data types. You must assign a spatial data type to each table or view column that is to contain spatial data.
  • Spatial catalog tables and catalog views.
  • A spatial grid index, so that you can define grid indexes on spatial columns.
  • Spatial functions. You use these to work with spatial data in a number of ways; for example, to determine relationships between geometries and to generate more spatial data.
  • Definitions of coordinate systems.
  • Default spatial reference systems.
  • Two schemas: DB2GSE and SYSPROC.