Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    47

    Unanswered: restore gone bad in Control Center

    db2 v8 FP 12 Windows 2003.

    I was using Control Center for restore, but got an error. It seems that somewhere it is still connected, but I cannot see that in db2 list applications. It appears that it didn't issue a terminate command.

    Now during a command restore:

    RESTORE DATABASE mydb FROM "E:\sqlbackups\mydb" TAKEN AT 20081212145527 TO "E:" REDIRECT

    SQL2001N The utility was interrupted. The output data may be incomplete.

    terminate
    DB20000I The TERMINATE command completed successfully.

    connect to mydb
    SQL1119N A connection to or activation of database "mydb" cannot be made
    because a previous restore is incomplete. SQLSTATE=57019

    SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "E:\DB2\NODE0000\SQL00003\SQLT0000.0")
    SQL1024N A database connection does not exist. SQLSTATE=08003

    There are other table spaces, but I won't bore you with those.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You'll probably need to drop the database and repeat the restore from the beginning
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2007
    Posts
    47
    Quote Originally Posted by n_i
    You'll probably need to drop the database and repeat the restore from the beginning

    Thanks that seemed to work on another system that I was having problems with. On the other ssystem I get "database in use" even though db2 show applications show no one connected.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by bic
    I get "database in use" even though db2 show applications show no one connected.
    LIST ACTIVE DATABASES
    DEACTIVATE DB ...
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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