Prepare DB2

Before you can create multi-user workspaces where several users have access to the same data, first you need to prepare your common repository.

To prepare a DB2 environment, follow the steps below:

• Meet the database requirements for multi-user mode

• Prepare the database

Prepare the database

Make sure the user who prepares the DB2 server for common repositories has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER.

To prepare your database, follow these steps:

1. Create a database on the database server.

2. To create the tables, adapt the Create Tables DB2.sql script to your requirements and then run it.

   You can find the script in %COMMANDER_HOME%\SQL\DB2.

What's next

Now that you have prepared the database, you can create your workspaces. For information on how to do so, see chapter "Create Oracle, MS SQL Server, or DB2 workspaces".