To upgrade to the new
data model, perform the following steps:
-
Make a new IT data mart.
Use the
Adapter Setup wizard to create a
new IT data mart for the same adapter, or set of adapters, that were
located in your old IT data mart. This new IT data mart will contain
your upgraded data after this upgrading process has successfully completed.
The following table
can help you determine which ITRM 3.21 adapter to choose when upgrading
a data mart from a previous release.
Cross-Reference Table of Collectors and Adapters
ITRM 2.6 and 2.7 Collectors
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-
Generate a comparison
report of the two IT data marts.
The supplied SAS macro,
%RMUPGRDM, can be run from an interactive session of SAS, or by creating
a SAS program and running it in batch mode. This macro is used both
to create the comparison report and to perform the IT data mart upgrade.
To generate the comparison report without performing an update, set
the
DOPREPORT parameter to
YES and the
DOUPGRADE parameter to
NO.
Based on the comparison
report, you might determine that you would lose some data that you
want to keep. In that case, you can use SAS IT Resource Management
to edit the new IT data mart. You can add columns, edit existing columns,
and delete unwanted columns. You can also create new tables, modify
existing tables, and delete unwanted tables.
Note: If you change or delete any
columns or tables, some of the supplied reports might not work.
After making changes,
rerun the upgrade program with the
DOREPORT parameter set to
YES. You can use
the report to see how your changes could affect the upgrade. Once
you determine that all the data will be carried forward to your satisfaction,
continue to the next step.
-
Upgrade the IT data
mart.
In order to upgrade
the IT data mart, you need to use the same macro that you used to
create the comparison report: %RMUPGRDM. You should change two parameters
in order to upgrade the data. Change the value of the
DOREPORT parameter to
NO and the value of the
DOUPGRADE parameter
to
YES.
The Upgrade program
copies the physical data tables from the old IT data mart to the new
IT data mart and makes the necessary changes to the columns.
This program does not
delete your old data. The data is still available in the old IT data
mart's location. Once you are confident that the upgrade was successful,
you can delete the data manually or by using the
Erase
Data Mart action in SAS IT Resource Management.