Home / server / Questions / 270830
Accepted
Radek
Asked: 2011-05-18 22:06:41 +0800 CST

cannot drop existing db2 database

  • 772

db2 list database directory gives me 

Database 1 entry:

 Database alias                       = M
 Database name                        = M
 Local database directory             = /var/lib/edumate/database
 Database release level               = d.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

buuuuut

db2 drop database M gives me

SQL1013N  The database alias name or database name "M       " could not be 
found.  SQLSTATE=42705

and /var/lib/edumate/database/db2inst1/NODE0000 doesn't have M directory

any suggestion on how I can remove the database m from the system?

db2

1 Answers

  1. Best Answer

    try this:

    db2 uncatalog database M
    • 1