Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012

    Question Unanswered: Effect of Restore on Federation


    We have a database A on DB2 9.7 LUW which is federated with a Mainframe database. Also there is another database which is federated to this database A. We have to perform restore on A, what will be the impact on the federation ? Will the restore impact the existing restore ?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    If you are restoring it to the same server for the same instance, then as long as there were no changes to the database catalog, the restore should not have any impact on federation. Now if there were any changes to the federation setup for database A that were made after the backup image that will be restored, then those will be lost.

    Also any changes made to the remote database that federates to Database A that were made after the backup will need to be checked out as they maybe invalid after the restore.

    Quote Originally Posted by siddharth1988 View Post
    Will the restore impact the existing restore ?


  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    Which database is the federated server and which the remote server? Andy explained the restore on the federated server. If you do a restore on the remote server, you will now see the old data if queried via the federated server. This also assumes that no schema changes were done, of course.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Tags for this Thread

Posting Permissions

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