DB2 Error Code – -909 the object has been deleted

In this post, you’ll learn about the error message -909 the object has been deleted in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-909 the object has been deleted

Reason for the Error

The application program has either (1) dropped a table and then attempted to access it, or (2) dropped an index and then tried to access its object table using that index.


The logic of the application program must be corrected such that it does not attempt to access or use an object after it has been dropped. Dropping indexes within an application program is especially hazardous, because there is no way of determining whether or not the plan that has been generated for the application (by BIND or REBIND) actually uses a particular index for access to its object table.