Upgrading to the New Data Model

To upgrade to the new data model, perform the following steps:
  1. 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.2 adapter to choose when upgrading a data mart from a previous release.
    Cross-Reference Table of Collectors and Adapters
    ITRM 2.7 Collectors
    ITRM 3.1.1 Adapters
    ITRM 3.2 Adapters
    TMON2CIC
    TMON2CIC
    ASG TMON2CIC
    TMONDB2
    TMONDB2
    ASG TMONDB2
    IMF
    IMF
    BMC Mainview
    Patrol
    PATROL
    BMC Perf Mgr
    TMS
    TMS
    CA TMS
    NTSMF
    TOOLNM=SASDS
    NTSMF
    DT Perf Sentry
    NTSMF
    TOOLNM=MXG
    NTSMF-MXG
    DT Perf Sentry with MXG
    HP-PCS
    HP-OVPA
    HP Perf Agent
    HP-OVREP
    HP Reporter
    DCOLLECT
    DCOLLECT
    IBM DCOLLECT
    EREP
    EREP
    IBM EREP
    SMF
    SMF
    IBM SMF
    TPF
    TPF
    IBM TPF
    VMMON
    VMMON
    IBM VMMON
    MS SCOM
    SAPR3
    (TOOLNM=SASADAPT)
    SAPR3
    SAP ERP
    SAR
    SAR
    SAR
    SNMP
    VMware vCenter
    WRBLOG
    Web Log
  2. 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.
  3. 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.