Changing the database location and backup interval

After you install and configure Report Builder, a database stores all the Report Builder configurations and report definitions in a location. You can change this location. Every six hours, the Report Builder database is backed up so that you can restore the data if an error occurs.

Changing the database location

The Report Builder configurations and report definitions are stored in the [RBInstallDir]/server/conf/rs/db directory.

Before you begin

  • You must have JazzAdmins or JazzProjectAdmins privilege.
  • The installation folder for Report Builder ([RBInstallDir]) might be the same as other applications such as Jazz Team Server or IBM® Engineering Workflow Management.

Procedure

  1. Create the folder that you want to use.
    For example, E:\rs\db.
  2. Stop the Report Builder application.
  3. Move the content of [RBInstallDir]\server\conf\rs\db to the new folder E:\rs\db.
  4. Rename [RBInstallDir]\server\conf\rs\db to prevent confusion.
  5. Open [RBInstallDir]\server\conf\rs\app.properties in a text editor, and add the following line: 
    DBLocation=[Absolute path to the new database folder]
    Tip: The path is passed to the Java file type so it requires forward slashes. For example, DBLocation=E\:/rs/db.
  6. Start the Report Builder application.

What to do next

If the database relocation is not successful, a new database is configured at [RBInstallDir]\server\conf\rs\db. If this happens, follow these steps:
  1. Stop the Report Builder application.
  2. Delete the [RBInstallDir]\server\conf\rs\db folder.
  3. Analyze the errors in the rs.log file.

Changing the database backup interval

You can change the backup interval by updating the JTS_install_dir/server/conf/rs/app.properties file.

About this task

Report Builder uses a Jena TDB database. The backup mechanism includes these steps:
  • Verifies that the database can be read
  • Copies the database to the JTS_install_dir/server/conf/rs/db_backup directory
  • Adds or updates the jena.tdb.backup.last.date= property in the JTS_install_dir/server/conf/rs/app.properties file

You can configure the backup interval in the app.properties file. The jena.tdb.backup.interval= property is set to 360 (the value in minutes), but you can change this value.

Attention: If the Jena TDB cannot be read, you get an error. For more information, read Resolving a corrupt database error.

Procedure

  1. Open the conf/rs/app.properties file.
  2. Find the jena.tdb.backup.interval= property and change the value.