Step 3: Establishing the database credentials

You must establish the credentials of the database dedicated to Rule Execution Server if you are using database persistence.

About this task

These credentials are required to establish the datasource, which you will do in the next step.

If a database does not already exist, create one now by following the instructions for that database type. The procedure below shows how to create an empty Derby database.

Note: Skip to the next step if you are using the embedded Derby database.

If you set persistence to file, you can skip all the database-related tasks and proceed to Step 6: Deploying the Rule Execution Server Management EAR.

Procedure

Stop the application server.
Launch <DerbyInstallDir>/bin/ij.bat (or ij for Linux).
Create the database and connect to it.
For example, to create the new database c:/resdb as the user resdbUser and connect to it, use the following command:
```
ij>connect 'jdbc:derby:c:/resdb;user=resdbUser;password=resdbUser;create=true';
```
Close the ij utility.
```
ij> quit;
```
Start the application server.

Creating a DB2 database on z/OS

Before you begin

You must first install DB2 and set the appropriate rights on the database, and then customize JCL.

Check that you have DB2® for z/OS® Version 9.1 or 10 installed
Check that you have DB2 Administrator authority to CREATE a database and CREATE & UPDATE tables.DB2.

About this task

After you have customized the JCL variables for your configuration, you can submit the jobs to create a database for Rule Execution Server.

Procedure

Customize the JCL as indicated in the comments within each PDSE member, before you run them on the z/OS system.
You can customize the JCL either by using a manual search-and-replace, or by using an ISPF macro.
On the z/OS computer where DB2 is installed, run the following JCL scripts to create the RULEAPP tables, XOM table, EXECUTION_TRACES tables, and grant authority to the tables. The database administrator typically performs this task. ++DB2USER++ is the user ID to access DB2.
1. InstallDir/executionserver/jcl/HBRDSCDB.jcl
2. InstallDir/executionserver/jcl/HBRDSXOM.jcl
3. InstallDir/executionserver/jcl/HBRDSCTR.jcl
4. InstallDir/executionserver/jcl/HBRDSGRN.jcl