Use this stored procedure to supply a database with the resources that it needs to store spatial data and to support operations. These resources include spatial data types, a spatial index type, catalog tables and views, supplied functions, and other stored procedures.
For an example of the code for invoking this stored procedure, see the C function gseEnableDB in the sample program. For information about this program, see Writing applications for DB2 Spatial Extender.
The user ID under which the stored procedure is invoked must have either SYSADM or DBADM authority on the database that is being enabled.
Output parameters
Table 13. Output parameters for the db2gse.gse_enable_db stored procedure.
| Name | Data type | Description |
|---|---|---|
| msgCode | INTEGER | Code associated with the messages that the caller of this stored procedure can return. |
| Reserved | VARCHAR(1024) | Complete error message, as constructed at the DB2 Spatial Extender server. |