Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Drop database left some settings befind, so create database can't be executed

    Hi,
    on db2 enterprise v8.2 fp 11 on Linux I have drop the database and it looks like drop database was not correctly done.

    When executing command:
    Code:
    db2 restore database mydb from /backup/ to /workingdir/db into mynewdb
    error was returned: SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

    I tried to restore to different directory
    Code:
    db2 restore database mydb from /backup/ to /workingdir/dbnew into mynewdb
    and restore commpleted successfully.

    It looks like drop database was not correctly done. How can I "clean up" settings that have been left from drop? I would like to restore database to my original directory?

    Thanks,
    Grofaty

  2. #2
    Join Date
    Apr 2008
    Posts
    39
    Do blastdb. It will drop the database and do all cleanup.

    Thanks,
    Madhavi.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    thanks a lot. I have solved the problem by removing all files/directories/subdirectories with Linux rm command from /workingdir/db directory and now restore database works fine.
    Thanks,
    Grofaty

Posting Permissions

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