Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Question Unanswered: db2 restore from backup

    Hi Folks,

    DB2 V7 on red hat 8.

    Here's the format of one of the files from the backup -
    ABC.0.db2inst1.NODE0000.CATN0000.20040225010003.00 1.gz

    The problem? is I dont think the db2 instance/database to which these files belong exists any more.

    How do I go about restoring these files into a database?
    Restore these files into a new instance/database?
    Is that possible??

    Appreciate your help!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes you should be able restore it into a new database/instance.
    Look at the RESTORE command in the Command Reference manual.

    DB2 does not put a .gz extention on backup images, so I am assuming that someone zipped up the image to .gz . You will need to unzip it before you can restore from it.

    Andy

  3. #3
    Join Date
    Aug 2004
    Posts
    4

    Question db2 restore

    hey Andy,

    For the restore into a new instance, should the instance be named - ABC ?(picked this up from the backup file - the first string)

    Regards.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Backup images on Linux are named in the following manner:

    DB_Alias.Type.Instance_name.Node_number.Catalog_No de_number.Timestamp.sequence number


    So for your image:

    DB_Alias = ABC
    Instance = db2inst1
    Timestamp = 2004-02-25 01:00:03

    You only have a single node and only one file was generated.

    Andy

  5. #5
    Join Date
    Feb 2002
    Posts
    96
    You can restore from instance name A to instance name B.
    Similary from database name C to database name D.

    So, the instance name & database name will not be a problem when you restore into different name.

    Regards
    Prakash

Posting Permissions

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