db2se unregister_gc command

The db2se unregister_gc command unregisters a geocoder.

To find information about the geocoder that you want to unregister, consult the DB2GSE.ST_GEOCODERS catalog view.

Authorization

The user ID must have DBADM and DATAACCESS authority on the spatially enabled database to run this command.

Command syntax

db2se unregister_gc command

Read syntax diagramSkip visual syntax diagramunregister_gcdatabase_name-userIduser_id-pwpassword -geocoderNamegeocoder_name

Command parameters

Where:
database_name
Specifies the name of the database for which you want to unregister a geocoder.
-userId user_id
Specifies the database user ID that has DATAACCESS authority on the database indicated by database_name.
-pw password
Specifies the password for user_id.
-geocoderName geocoder_name
Uniquely identifies the geocoder that you want to unregister. The geocoder_name value is converted to uppercase unless you enclose it in double quotation marks. The maximum length for this parameter is 128 characters.

Usage notes

You cannot unregister a geocoder if it is specified in the geocoding setup for any column. To determine whether a geocoder is specified in the geocoding setup for a column, check the DB2GSE.ST_GEOCODING and DB2GSE.ST_GEOCODING_PARAMETERS catalog views.

Examples

The following example unregisters a geocoder named MYGEOCODER.

db2se unregister_gc mydb -geocoderName mygeocoder