Database replication

Database replication technology is being used to move business measures model related data from the State database to the Runtime database and from the Runtime database to the Historical database.

To setup replication for a business measures model between the State, Runtime and Historical database, the following high level tasks need to be performed:
  1. Generate replication setup scripts. The Schema Generator analyzes the business measures model for which replication has to be set up and generates a set of setup files.
  2. Distribute replication setup scripts. These setup files have to be manually transferred to the machines hosting the State, Runtime and Historical databases.
  3. Execute replication setup scripts. Each one of the setup files will upon execution create the necessary database objects and configure the utilities that move the data from one database to another.
Upon successful completion, the replication utilities can be started and are operational. The following sections provide an in-depth architectural view and explains some of the fundamental concepts used.

Copyright IBM Corporation 2005, 2006. All Rights Reserved.