Derby database and dashboard data backup and restore

The H2 database stores the Network Performance Insight® Dashboards data. Some of the information that is stored in Derby database; the list of dashboards, users, roles, page-role mapping information, dashboard state, and database queries that are used for dashboard pages, and so on. The backup operation includes both H2 database and other Network Performance Insight Dashboards related data.

Before you begin

Identify the Network Performance Insight host in your cluster that is integrated with Jazz® for Service Management and perform the following steps:
  1. Log in to the Dashboard Application Services Hub server as npiadmin user.
  2. In the navigation pane, select Console Settings > (Console settings) > Console Integrations.
  3. Click the NPI link and note down the Console Integration URL. For example,
    https://<myserver.ibm.com>:9443/Blaze/rest
    Note: You need the <myserver.ibm.com> hostname to understand from where to back up the data.

About this task

You must backup the Derby database and dashboards data from the Network Performance Insight host that is integrated with Dashboard Application Services Hub, and then restore the data back to another host in a multi-node environment. These steps are applicable if you have a single node environment.

All the required data is available in the /opt/IBM/basecamp/basecamp-dashboard folders.