Each month, one sub-PowerCube is generated containing data
for the past month. These sub-PowerCubes are stored on the disk as
files that you can use for backing up and restoring a month’s worth
of data in the PowerCube.
About this task
Backing up a sub-PowerCube only preserves one month’s
data at a time. Rebuilding a PowerCube requires a full restore from
the raw Metrics database. For information on restoring an entire PowerCube,
see Restoring
the entire Metrics database and PowerCube or Restoring the Metrics
database and PowerCube incrementally.
Procedure
- To back up a month’s worth of PowerCube data, copy the
previous month’s sub-PowerCube file to a different server:
Back
up the most recent sub-PowerCube that contains data for an entire
month; do not back up the current month’s data because it is incomplete.
- On the server hosting the IBM® Cognos® Transformer component,
navigate to the Powercube_save_path/MetricsTrxCube directory,
which is where sub-PowerCube files for each month are stored.
The Powercube_save_path is
the value of the cognos.cube.path
property specified
in the cognos-setup.properties file.
- Copy the sub-PowerCube for the previous month to the
backup location.
- To restore a PowerCube, copy the backed-up version of the
sub-PowerCube back to the original server:
- On the server storing the backup files, navigate to
the location of the saved PowerCube file and copy the most recent
month’s backup file.
- On the server hosting the IBM Cognos Transformer component,
copy the retrieved file to the Powercube_save_path/MetricsTrxCube directory.
- Either wait for the scheduled cube refresh job to run,
or run it manually.
After the cube refresh job
finishes, the changes are updated to the Cognos server.