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 these steps:

  1. Make sure you meet the database requirements.

  2. Install DB2 drivers.

  3. Prepare the database

Install DB2 drivers

To use DB2 as a common repository, you need to download and install the .NET Core DB2 driver:

  1. Download Net.IBM.Data.Db2 from NuGet (opens in new tab).

  2. Copy the following objects from the download package into %COMMANDER_HOME%:

    • The file IBM.Data.Db2.dll from the lib\net8.0 folder.

    • The subfolder clidriver from the buildTransitive folder.

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