Installation Settings Wizard: Creating the database schema

You must create the Decision Center database schema before you perform any other installation task.

Before you begin

If you use DB2® z/OS® for the Decision Center database schema, do not go through 1 of the Installation Settings wizard to create or re-create the schema. Instead, have the database administrator execute the provided JCL scripts.

If you work with WebSphere® Application Server, see Creating the DB2 database.

Attention: Before you modify your database, make sure that you have an adequate backup.

About this task

To create the database schema, you must do the following tasks:
  • Generate a script to create the tables in the database
  • Include any rule model extensions
  • Execute the script

Decision Center stores rule model extensions in two XML files. One of the files contains the model description and has the file extension .brmx. The other file contains data to initialize enumerations and hierarchies, and has the file extension.brdx.

Procedure

To create the database schema by using the Installation Settings wizard:

  1. On the Installation Settings wizard Home tab, click Next and then select Step 1: Configure Database.
    If this is not the first time you have modified the database, you get the following prompt:
    Some existing data has been found in the Decision
Center database.
What would you like to do?
 * Generate a script that keeps my data
 o Generate a script that erases the existing data and recreates the schema
  2. Choose one of the following options:
    • Generate a script that keeps my data: Decision Center generates an SQL script that keeps existing data. Choose this option if, for example, you want to update an existing database schema after a new property has been added for rules in the rule model.
    • Generate a script that erases all previous data and re-creates the whole schema: The script drops the tables in the database and re-creates the database schema.
  3. Under Select the extension files you want to use, select one of the following options:
    • Default extensions: The default extensions are available in <InstallDir>\teamserver\bin.
    • Custom extensions (brmx/brdx): Specify the location of your model extension (.brmx) and data extension (.brdx) files.
    • Custom extensions (zip): Specify the location of your .zip files.
    Note:

    The contents of the files must comply with ISO-8859-1. ISO-8859-1 is a standard character encoding of the Latin alphabet, also known as Latin-1.

  4. Click Generate SQL.

    This command generates the SQL script that you use to create your database tables, based on the contents of the rule model and the extension files. When completed, the Installation Settings wizard confirms that the rule-team-server.sql script has been generated.

  5. Check the Execute the SQL script option.

    You clear this box only if you choose to execute the SQL script outside the Installation Settings wizard. In this case, follow the instructions in section Running the SQL script outside the Installation Settings Wizard.

  6. Click one of the following buttons:
    • Finish to execute the SQL script and initialize the database,
    • Apply for subsequent configurations of your database,
    • Next to execute the script, initialize the database, and continue to use the Installation Settings wizard. For example, if you want to carry out the Message file setup step.
    Note:

    Initializing the database means uploading the extension model and the default message file (if using the default extension model) to the database.

Results

You can now publish rule projects to your database. You can also view your extension model and data in Configure > Diagnostics.

Parent topic: Overview: Installation Settings Wizard