Results 1 to 3 of 3

Thread: uncatalog a db

  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: uncatalog a db

    Hi All,
    Below are operations I am performing in sequence.
    >db2 create database xxx
    SQL1005N The database alias "xxx" already exists in either the local
    database directory or system database directory.

    >db2 connect to xxx
    SQL30061N The database alias or database name "xxx " was
    not found at the remote node. SQLSTATE=08004

    >db2 catalog database pca_u
    SQL1005N The database alias "xxx" already exists in either the local
    database directory or system database directory.

    >list db directory
    Database 7 entry:
    Database alias = xxx
    Database name = xxx
    Local database directory = C:
    Database release level = b.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    How can I completely uncatalog this previously cataloged database named 'xxx' so as to create a new DB with the same name???

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Is this a trick question?
    Code:
    db2 uncatalog db xxx
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2 catalog database xxx on c:
    db2 drop database xxx
    db2 create database xxx
    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
  •