Hi,

We have an script that runs every night and drops and recreates a database on a server.. I checked today and it doesn't seem like it was able to drop the database, I see this error message in the logs --

SQL1137W The database manager was unable to remove the database path or some
of the containers when dropping database "dbase". Cleanup is required.

I tried to uncatalog, catalog and create the database so I could drop it again but I get this ---

db2 drop database dbase
SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031


and because of this when i run the restore, I get this --

SQL1005N The database alias "dbase" already exists in either the local
database directory or system database directory. SQLSTATE=00000


How can I make sure that the database is completely dropped? Thank you!!

You will have to manually clean up the path that the DB resided on.

Andy

thank you, i think that worked

You don't really need to drop the database prior to restoring it - RESTORE will overwrite the existing database with the same name.