Configuring Database Instances

 Configuring Database Instances

Use

You configure the database instances that you want to synchronize.

Prerequisites

?     You use MaxDB software version 7.6 or higher.

?     You have created the database instance that will assume the role of master instance. See

0     Database Manager GUI, Creating a Database Instance

0     Database Manager CLI, db_create

?     You have created the database instances that will assume the role of client instances.

?     You have created the synchronization user in all the database instances.

See Database Manager GUI, Creating/Changing/Deleting a Synchronization User

?     You have designed a data model.

See Data Model.

All tables to be synchronized must have a primary key. You may not execute UPDATES for data in the primary key columns in tables that are participating in the synchronization.

Procedure

...

       1.      In the master instance, define the master tables, database users, and so on in accordance with your data model.

See

SQL Reference Manual, Data Definition

SQL Tutorial, Data Definition

       2.      Insert the data into the master table.

See

SQL Reference Manual, Data Manipulation

SQL Tutorial, Data Manipulation

Loader, Importing: Commands

       3.      In the client instances, define the client tables, database users, and so on in accordance with your data model.

Do not fill the client tables with data. Before you start the synchronization, initialize the client tables; the Synchronization Manager then copies all necessary data from the master tables to the client tables.

       4.      The synchronization user must be able to access all tables involved in the synchronization. Thus the database users who created the tables have to grant the synchronization user all privileges for these tables using the GRANT statement. See the Reference Manual, GRANT statement (grant_statement)

See also:

Technical System Landscape