Results 1 to 5 of 5
  1. #1
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221

    Unanswered: DB2 Backup/restore issue

    Can you restore a DB2 database just from its backup file.....

    i.e.
    i have backed up a database so i have the backup file DB.0.db2inst.NODE0000.CATN0000.20070507030007.001

    now i delete the database

    can i just restore the database using this file and nothing else...is it possible????

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It depends on how the backup was performed. If it was an offline backup then the answer is yes. If it was an online backup and the log files were included, then the answer is again yes. Otherwise, you will need some log files to be able to get a working DB.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Also, multiple backup images are needed if you took delta/incremental backups.

    And if you mean with "delete a database" that you just remove it from control center, be aware that this will only uncatalog the database and not drop it.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    so can you just tell me how to go about it coz i am not able to find a solution for the same.....and i am not able to restore the database........

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by nick.ncs
    so can you just tell me how to go about it coz i am not able to find a solution for the same.....and i am not able to restore the database........
    1) what DB2 version and OS are you using?
    2) what is the exact BACKUP command used to produce the backup image?
    3) what exactly did you do to "delete" the DB?
    4) what is the RESTORE command you are using? Are you getting errors? If so, what are they?

    Andy

Posting Permissions

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