DB2 Error Code – -679 the object name cannot be created because a drop is pending on the object

In this post, you’ll learn about the error message -679 the object name cannot be created because a drop is pending on the object in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-679 the object name cannot be created because a drop is pending on the object

Reason for the Error

The application program has executed a DROP for the specified object, and then tried to re create an object with the same name`(and of the same type) before the DROP was completed.

Solution

The logic of the application program must be modified to issue a COMMIT (or the IMS/VS or CICS equivalent) between the DROP and CREATE statements.