1

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?

1 Answer 1

1

try this:

db2 uncatalog database M
5
  • 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, 2011 at 23:21
  • Not sure why it didn't work before but it worked today :-) Thank you.
    – Radek
    Oct 11, 2011 at 5:51
  • And it doesn't work today :-)
    – Radek
    Nov 28, 2011 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, 2012 at 5:09
  • It happened again :-( created support ticket with IBM support.
    – Radek
    May 21, 2012 at 0:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .