drop_idx

Use the drop_idx command to drop a spatial index.

Authorization

The user ID under which the command is invoked must have one of the following authorities and privileges:
  • SYSADM or DBADM authority on the database that contains the table where the spatial grid index is used
  • Ownership or INDEX privilege on the table

Command syntax

DSN5SCLP /drop_idx DALLAS
	[-indexSchema idx_schema]
	-indexName idx_name

Parameter descriptions

All parameters are required and case-sensitive unless otherwise indicated.

-indexSchema
Identifies the schema to which the index that is specified in the -indexName parameter belongs. This parameter is optional.

If this parameter is not specified, the value in the CURRENT SCHEMA special register is used as the schema name for the index.

-indexName
Identifies the name of the index that is to be dropped. You must specify a non-empty value for this parameter.

Example

This example shows how you can use the drop_idx command to drop the spatial index named LOCIDX from the DB2GSE schema.
DSN5SCLP /drop_idx DALLAS +         
-indexSchema DB2GSE -indexName LOCIDX