Step 3: Setting up your database
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.
Before you begin
About this task
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.
Procedure
To create an empty Derby database:
Creating a DB2 database for Linux on z Systems
Customizable scripts are provided to create your DB2® database schema, but you must first create an empty database.
Before you begin
Procedure
su {DB2AdminName}
db2
CREATE DATABASE {RESDBName}
What to do next
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.
Creating a DB2 database on z/OS
Before you begin
- 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.