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.