For details on the supported database systems, see the "Supported Environment" section of the release notes. Details of the requirements when installing and operating the database can be found in the documentation for the particular DBMS.

As with other external databases, we recommend that you create a new database instance for use by the IGEL UMS.

Perform the following steps to create a new database instance and define the instance as a data source in the UMS Administrator:

  1. For security purposes, enable User Authentication in the Derby DB.

  2. Launch the ij Utility (in [derby-installation-dir]/bin).

  3. To create the rmdb instance, execute the following command:
    connect 'jdbc:derby://localhost:1527/rmdb;user=dbm;password=dbmpw;create=true';

  4. Create the schema rmlogin using the following command:
    create schema rmlogin;

  5. Define the UMS database user rmlogin with the password rmpassword:
    CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.rmlogin', 'rmpassword');

  6. Exit ij and launch the Derby Network Server.

  7. In the UMS Administrator, create a new data source with the following parameters:
    DB type: Derby
    Host: Name of the Derby Server
    Port: Port of the Derby Server. (Default: 1527)
    User: rmlogin
    Database / SID: rmdb

For further information regarding installation of the Derby database, see http://db.apache.org/derby.