In this post, you’ll learn about the error message -601 the name of the object to be created is identical to the existing name name of the object type obj type in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-601 the name of the object to be created is identical to the existing name name of the object type obj type
Reason for the Error
The CREATE statement sought to create an object ‘name’ of type ‘obj type’ when there is already an object of that type with the same name defined in the DB2 subsystem.� If ‘obj type’ is constraint, the ‘name’ was specified in the FOREIGN KEY clause of either a CREATE or ALTER TABLE statement.
Solution
Either the existing object must be dropped or another name must be chosen for the new object.� If ‘obj type’ is data set, an IDCAMS DELETE of the data set must be done before the CREATE is retried.
