If you are using database persistence, you must first create an empty schema for the database that is dedicated to Rule Execution Server and establish the credentials.
.
The credentials to access the database are required to establish the data source, which you do in Creating a data source and connection pool.
If a database does not exist for Rule Execution Server, create one now by following the instructions for that database type.
To create an empty Derby database:
Customizable scripts are provided to create your DB2® database schema, but you must first create an empty database.
su {DB2AdminName}
db2
CREATE DATABASE {RESDBName}
To set up the database, you can use the Rule Execution Server console or you can run the SQL scripts that are provided in <InstallDir>/executionserver/databases. A readme file in this directory provides more information about the scripts.
After you have customized the JCL variables for your configuration, you can submit the jobs to create a database for Rule Execution Server.