Restoring sample databases

You can restore sample databases to their initial state by using the Samples Console or an Ant command.

About this task

The sample server provides the following databases:
  • resdb contains the Rule Execution Server sample database.
  • rtsdb contains the Decision Center sample database.
  • rtsdb-serverextendedbrm contains the Decision Center sample database for the Complex rule model extension sample, which needs a specific database schema. See Sample: Complex rule model extensions.

The easiest way to restore the databases is to click the Restore the sample server button "" in the Samples Console. The Console view displays feedback messages as the database is being restored.

You can also use an Ant task, as explained in the following procedure. To do so, you must first define the ANT_HOME variable (see Setting up your environment to use Ant).

Important: If you want to keep the modifications in your existing databases, create a backup of the databases that are located in <ServerDir>/usr/server/<ProfileName>/data/h2. ServerDir is the location of the WebSphere® Liberty application server that you gave during the installation, and ProfileName depends on your version number.

Procedure

  1. Stop the sample server if it is running.
  2. Open a command prompt, and go to <InstallDir>/shared/bin/.
  3. Type ant restoredb and press Enter.
  4. Start the sample server.