Prepare DB2

The user who prepares the DB2 server for common repositories needs to have the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE, CREATE, ALTER, and DELETE.

To prepare your database, follow the steps below:

1. Create a database on the database server.

2. To create the tables, run the SQL script Create Tables DB2.sql against the database. This script is located at %COMMANDER_HOME%\SQL\DB2.

   You have to adapt the script to your local requirements and conditions.

To delete a schema, you need DROP rights.

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".