db2 v8 FP 12 Windows 2003.

I was using Control Center for restore, but got an error. It seems that somewhere it is still connected, but I cannot see that in db2 list applications. It appears that it didn't issue a terminate command.

Now during a command restore:

RESTORE DATABASE mydb FROM "E:\sqlbackups\mydb" TAKEN AT 20081212145527 TO "E:" REDIRECT

SQL2001N The utility was interrupted. The output data may be incomplete.

terminate
DB20000I The TERMINATE command completed successfully.

connect to mydb
SQL1119N A connection to or activation of database "mydb" cannot be made
because a previous restore is incomplete. SQLSTATE=57019

SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "E:\DB2\NODE0000\SQL00003\SQLT0000.0")
SQL1024N A database connection does not exist. SQLSTATE=08003

There are other table spaces, but I won't bore you with those.

You'll probably need to drop the database and repeat the restore from the beginning

Thanks that seemed to work on another system that I was having problems with. On the other ssystem I get "database in use" even though db2 show applications show no one connected.

LIST ACTIVE DATABASES
DEACTIVATE DB ...