Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007

    Unanswered: Drop Database That is NOT in the local database directory

    I've got DB2 v 9.1. I'm doing a db2 list db directory:
    Database 10 entry:

    Database alias = BRUCE
    Database name = BRUCE
    Local database directory = /db2_data/database
    Database release level = b.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Then trying to drop this BRUCE database and get this message:
    SQL1013N The database alias name or database name "BRUCE " could
    not be found. SQLSTATE=42705

    SQL1013N Error:
    If the database name appears in the system database directory
    and the entry type is INDIRECT, ensure that the database exists
    in the specified local database directory. If the entry type is
    REMOTE, then ensure that the database exists and is cataloged on
    the database directories of the server node.

    The database is not in the local database directory. I'm not sure what to do from here. My goal is to remove the BRUCE database.

    Thank you.


  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    If the db is not in the local db directory, then just uncatalog it from the system db directory using "db2 uncatalog db <db name>"

  3. #3
    Join Date
    May 2003
    After you uncatalog it, you may have to find the location of the files and delete them manually if they are still around.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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