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
    Aug 2001
    Location
    UK
    Posts
    4,650
    Issue
    db2 uncatalog database javaprod

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

  3. #3
    Join Date
    Feb 2005
    Posts
    36
    It seems I was able to do uncatalog and catalog the database. but I still can't drop the database. Any idea?

    Thanks!
    Lan

Posting Permissions

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