Hi,

i try to create some DB´s with sample-content.

The Problem is, that the Database existed with the same name (and alias)
before.

Depending to an application i have to create these DB´s with the same name and alias.

How can i delete the Databases out of the System- locale-Databasedirectory?`

I tryed uncatalog but it seems that the DB-Alias is still registered ?

Can anyone help plaese?

Thanks in advance.

anwy

you can always drop a db : db2 drop database xxx
db2 list db directory
db2 catalog db xxx as yyyy on /path/
if you uncatalog - always execute db2 terminate (will also flush some resident setting/memory...)

Which catalog is it in?

1) LIST DATABASE DIRECTORY
2) LIST DATABASE DIRECTORY ON /path

(replace "/path" with your path)

If the database exists in (2) but not (1), catalog and drop.

If the database exists in (1) but not (2) (ie. you deleted the directory) then simply uncatalog.

If you're still having problems, post the entire error message and output of the LIST DATABASE DIRECTORY commands please.