Stored procedures

Use Db2® Spatial Extender stored procedures to set up Db2 Spatial Extender and create projects that use spatial data.

You can call Db2 Spatial Extender stored procedures explicitly from an application program or implicitly when you set up Db2 Spatial Extender or issue a Db2 Spatial Extender command. For example, when you issue the db2se create_srs command, the DB2GSE.ST_CREATE_SRS procedure is called.

Before calling most of the Db2 Spatial Extender stored procedures on a database, perform the following tasks:
  1. Ensure that you have a system temporary table space with a page size of 8 KB or larger and with a minimum size of 500 pages. This is a requirement to be able to successfully run the ST_ENABLE_DB STORED procedure or the db2se enable_db command.
  2. Enable the database for spatial operations by invoking the ST_ENABLE_DB procedure. See ST_ENABLE_DB procedure for details.

After a database is enabled for spatial operations, you can connect to it and call any Db2 Spatial Extender stored procedure, either implicitly or explicitly.

The implementations of the stored procedures are archived in the db2gse library on the Db2 Spatial Extender server.