This topic describes how to migrate your reporting data
from version 2. This topic applies if you are using the out-of-the-box
BIRT reports, Rational® Common
Reporting, or Rational Insight.
Before you begin
Perform the following steps to migrate your version 2 reporting
data to the version 3 common data warehouse.
You must perform
these steps after upgrading the Jazz™ Team Server and
the Quality Management application, but before running the data collection
jobs (ETLs) or Data Manager (DM) ETLs in the case of Insight on the
upgraded server for the first time.
In a distributed environment,
the repotools-jazz commands described below should
be run on the Quality Management server.
Procedure
- Start the Quality Management server.
- If you used Rational Common
Reporting or Rational Insight,
migrate the version 2 data warehouse by running the repotools-jazz
-migrateDatawarehouse schema=/path/to/xdc adminUserId=id adminPassword=id command
on the upgraded Quality Management server.
where schema=/path/to/xdc is
the file location of the version 2 Rational Common
Reporting XDC configuration file for the data warehouse.
The
default path on Windows for
the version 2 XDC configuration file is C:\Program Files\IBM\RQM201\server\cognos\deployment\xdc\Configurations\rqm.xdc.
The default path on Unix is /opt/IBM/RQM201/server/cognos/deployment/xdc/Configurations/rqm.xdc.
If the file was installed elsewhere, you can find its location by
looking up RQM in the ODBC Administrator panel.
For further
details, see -migrateDatawarehouse.
- Point your browser to the Quality Management Application
Administration page (https://[fully qualified hostname]:9443/jazz/admin)
and verify that the setting
is set to true. This is required for the data collection jobs to start.
- Run the data collection jobs (ETLs) from the administration
URL on the Jazz Team Server at https://[host
name:port number]/jts/admin. For additional details, see Running the data collection jobs.
If
you use Insight, run the Data Manager (DM) ETLs instead of the data
collection jobs. For more information about upgrading with Insight,
see Upgrading Insight with Rational Quality Manager.
If
this is the first time you are running the data collection jobs in
version 3, and you have a large amount of data, this process can take
a significant amount of time.
- Migrate the execution trend data by running the repotools-jazz
-migrateExecutionTrendData adminUserId=id adminPassword=id command
on the Quality Management server. For details, see -migrateExecutionTrendData.
What to do next
After completing these steps, you must update the report
templates, and if you are using Rational Common
Reporting, update to Rational Reporting
for Development Intelligence.