We have a requirement to failover/failback between two sites a database that has in flight transactions so that we can do maintenance on one site and not totatlly stop access.
We would like to not have to script a redirected restore from one instance to another (ids are ida and idb for site delineation). So we would like to create the database and have it populated using generic schema so that we can easily export/import the data across sites and databases.
Is this possible? Has anyone done anything like this before? Or better still does anyone have any better ideas on how to accomplish this?
Replication will automatically copy data from one server to the other. There are serveral scenarios that can be set up. To learn more, look in the Replication Guide and Reference manual and there is a Redbook "A Practical Guide to DB2 UDB Data Replication V8". Both are good sources.
You may need Update Anywhere Replication set up ...
In your scenario, ideally there will be changes to only one side at any given point of time, but that needs to go to the other end ... Hence, you may find this set up easier to manage than two independent captures and subscription definitions
Visit the new-look IDUG Website , register to gain access to the excellent content.