"dbcache flush <databasename>"

The "drop dbnames.nsf" does not work for most cases. But maybe I do wrong.

Clustered mail-db, on one server

1 - mark replica as "out of service"

2 - drop user

3 - drop database

Database cannot be deleted and is still cached (dbcache show)

Thanks Daniel, indeed I was not aware about the drop command.

Ooops without reading my own comment I wrote something similar again ..

-- Daniel

you can use drop db.nsf

this is what also DBMT does if a database is in use. You even see the command on the console when DBMT runs.

On C-API I am using NSFDelete first and if that isn't successful I am taking the database offline.  This helps in most cases to delete the database.

But if the database is in use by a user/server a "drop" and also taking the database off-line will not always work.

You should try the "drop db.nsf"

[ Daniel Nashed / HCL Grandmaster / http://blog.nashcom.de ]

Daniel Nashed: You don't need to remove it from dbcache to do a copy-style compact.

You need to close the database itself. This can be done via "drop db.nsf"
The drop works for users and also for databases and is used by DBMT to get a database compacted.

You can see the commands invoked on the console when DBMT detects that the DB is in use :-)

There is a difference between open databases and databases in dbcache.

Try the following to see the details:

a.) dbcache show

b.) show dbs

And than try dbcache flush and drop db.nsf..

Does this help? Do you still think we need dbcache flush work on single databases?

-- Daniel

Torsten Link: fully agree with this request. Great Idea.