I cannot drop the Database and getting the error message SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019
What is the safest way to work around this problem?
Related Articles
Answer: The DB2 error message appears because the current database is not a valid state for the Drop Database Command you’re attempting to commit.
From the IBM DB2 LUW documentation “The database must not be in use; all users must be disconnected from the database before the database can be dropped”.
To fulfil the task deactivate the database and the complete the DROP DATABASE statement.
The DROP DATABASE command deletes all data & log files , so make sure you first have a valid backup , just in case.