Use this stored procedure to remove resources that allow DB2 Spatial Extender to store spatial data and to support operations performed on this data.
The purpose of this stored procedure is to help you resolve problems or issues that arise after you enable your database for spatial operations, but before you add any spatial table columns or data to it. For example, if, after you enable a database for spatial operations, it is decided to use DB2 Spatial Extender for another database instead. As long as you have not defined any spatial columns or imported any spatial data, you could invoke this stored procedure to remove all spatial resources from the first database.
For an example of the code for invoking this stored procedure, see the C function gseDisableDB in the sample program. For information about this program, see Writing applications for DB2 Spatial Extender.
Authorization
The user ID under which this stored procedure is invoked must have either SYSADM or DBADM authority on the database from which DB2 Spatial Extender resources are to be removed.
Output parameters
Table 8. Output parameters for the db2gse.gse_disable_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. |