Cannot drop database SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

16 June,2017 by Jack Vamvas

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?

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”.

Before you deactivate the database , speak with the application owner and negotiate a timeslot .

 

To fulfil the task deactivate the database and the complete the DROP DATABASE statement. Before you deactivate the database , complete a db2 force applications all.

 

The DROP DATABASE command deletes all data & log files , so make sure you first have a valid backup , just in case.

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Cannot drop database SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright