Error: Error Executing Stored Procedure: Db2gse

Error Message

Trying to delete a view results in the following error -

"Error executing stored procedure: db2gse gse_unregist_layerSDE_Database
Error: 0
00000
ODBC Error: 00000
Database Error: -11
Error Message: GSE0011E Spatial Extender could not disable or unregister object "".
SQLSTATE=00000
msg_code: -11"

Cause

This is a known issue with spatial extender.

Solution or Workaround

To delete a view, the you must be the db2 admin user and issue the following command:

db2 delete from db2gse.gse_layer where layer_table ='<view-name>'

Click on the link below for more information and a fixpack that is available through IBM technical support.

Article ID:000004580

Software: