Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Vietnam
    Posts
    5

    Unanswered: Help me to solve this error

    I receive the errow while trying to remove Sample DataBase

    " The database alias "SAMPLE" already exists in either the local database directory or system database directory."

    Pls tell me how to drop this database, (Pls be informed that I can not see it in Control Center to delete it)

    Thank you

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Help me to solve this error

    Do

    db2 list db directory

    and

    db2 list db directory on C:\

    IF the database appears in the second listing, do

    db2 catalog database <dbname> on C:\

    and then do a db2 drop database ....

    BTW, did you DROP DATABASE command ? or was it a delete of the directories ?

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •