Skip to Content
0
Former Member
Dec 08, 2011 at 03:45 AM

How to drop dependent object

557 Views

Hi Experts,

I am uninstalling SAP instance now and get stuck in the drop schema phase due to the following error:

drop schema DB2BJ1 restrict

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0478N DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "SCHEMA"

cannot be processed because there is an object

"DB2BJ1.EVMON_LOCKING_SCHEMA_SQL09070", of type "XSROBJECT", which depends on

it. SQLSTATE=42893

Please provide me the db2 command to remove the dependent object.

Thanks and Regards,

Rudi