Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: SQL1031N error help!

    Hi,

    I'm working on DB2 UDB 8.1 for AIX 5.3. I tried to do either db2 drop database mydb or connect to mydb command after I restored mydb from an online backup image using redirected restore. I got the following error:

    SQL1031N The database directory cannot be found on the indicated file system.
    SQLSTATE=58031

    so I list the database directory as following:
    $ db2 list database directory

    System Database Directory

    Number of entries in the directory = 2

    Database 1 entry:

    Database alias = JAVAPROD
    Database name = JAVAPROD
    Local database directory = /db2/longspace/db2prod1
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0

    Database 2 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Local database directory = /home/db2prod1
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0

    It seems mydb(javaprod) still exists. Does anyone can tell me on how to drop the javaprod from the db2 command line successfully?

    Thanks!
    Lan

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    drop db

    can you specify the exact command you type for the error
    drop - connect ??
    db2 drop database should do
    db2 list db directory on xxx should list the db's existing....
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    why donot you try : Uncatalog database mydb
    and see what happens?

Posting Permissions

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