Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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         =


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?

share|improve this question
up vote 1 down vote accepted

try this:

db2 uncatalog database M
share|improve this answer
I get SQL0965W There is no message text corresponding to SQL warning "77" in the message file on this workstation. The warning was returned from module "SQL09072" with original tokens "". – Radek Jun 2 '11 at 23:21
Not sure why it didn't work before but it worked today :-) Thank you. – Radek Oct 11 '11 at 5:51
And it doesn't work today :-) – Radek Nov 28 '11 at 0:51
Check the db directory (db2 list db directory) to see what it is cataloged. Also, take a look at the instance directory to see the databases defined there (the catalog tablespaces). With these two information you will know if there are still files for a database. – AngocA Feb 29 '12 at 5:09
It happened again :-( created support ticket with IBM support. – Radek May 21 '12 at 0:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.