dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

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 Tom Collins

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.

 

Related articles
DIA8400C A bad page was encountered
Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 3:07 AM in Backup & Restore, DB2 error tips, troubleshooting | Permalink | Comments (2)

I guess it would be good to mention

db2 force application all

In order to get rid of connected users fast & easy ;-) of course you should know what you're doing, just as whenyou want to drop a db

Posted by: Joachim Tuchel | Jun 19, 2017 12:31:20 AM

Joachim - db2 force applications all is a good idea, I've added to the steps

Posted by: Jack Vamvas | Jun 20, 2017 3:34:43 AM

Verify your Comment

Previewing your Comment

Posted by: |

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