DROP DATABASE fails

db2 db2-luw
John picture John · Jun 29, 2016 · Viewed 10.2k times · Source

I have a DB2 database (let's call it mydb) that I would like to delete. However, when I do db2 drop db mydb I get back

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

What am I doing wrong?

Answer

Finbarr O'B picture Finbarr O'B · Jul 6, 2016

You should try the following:

db2 quiesce db immediate
db2 force application all
db2 drop database mydb

'Quiesce' forces all users off the specified instance and database and puts it into a quiesced mode. (https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008635.html)

'Force application' forces local or remote users or applications off the system to allow for maintenance on a server. (https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001951.html)

If that doesn't do the trick, do 'db2stop' and 'db2start' after the 'force application' and then drop the database

Related questions

DB2 Comma Separated Output by Groups

Is there a built in function for comma separated column values in DB2 SQL? Example: If there are columns with an ID and it has 3 rows with the same ID but have three different roles, the data should be concatenated …

Read More
Failing update table in db2 with SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;

I am using db2 9.5 i have created a column in table which is created successfully but i am not able to update table column and getting following error [Error] Script lines: 1-1 -------------------------- DB2 SQL error: SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;…

Read More
Db2 connection problem with java

I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When i try to connect to database it is success full and while running any simple select query it give me …

Read More