Drop database on DB2 9.5 - SQL1035N The database is currently in use
Posted
by
Tommy
on Server Fault
See other posts from Server Fault
or by Tommy
Published on 2009-10-28T09:31:11Z
Indexed on
2011/01/17
18:54 UTC
Read the original article
Hit count: 500
db2
I've never got this working the first time, but now I can't seem to do i at all.
There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there are no connection to the database when I issue these commands:
db2 connect to mydatabase
db2 quiesce database immediate force connections
db2 connect reset
db2 drop database mydatabase
This allways give:
SQL1035N The database is currently in use. SQLSTATE=57019
running this command shows no connections/applications
DB2 list applications
I can even deactivate the database, but still can't drop it.
db2 => deactivate database mydatabase
DB20000I The DEACTIVATE DATABASE command completed successfully.
db2 => drop database mydatabase
SQL1035N The database is currently in use. SQLSTATE=57019
db2 =>
Anyone got any clues? I'm running the cmd-windows as the local administrator (windows 2008) and this is also the admin for DB2. The connectionpool-user cannot connect during quiesce-state.
© Server Fault or respective owner