Migrating the data warehouse

After you upgrade to IBM® Rational® Insight version 1.0.0.1, you must migrate your data warehouse to the new version.
Before you begin
Before you migrate your data warehouses, make sure that you are ready.
About this task

During the installation process, the migration scripts are placed on your file system. You must use these scripts to migrate your data warehouse.

To migrate the data warehouse:
  1. In the Rational Insight installation directory, navigate to the migration directory and then navigate to the database directory for your data warehouse. The default location is rational_insight_installation_directory/datawarehouse/dw/migration/.
  2. At the command prompt, run the following command:
    • Windows migrate
    • Linux ./migrate.sh
  3. When prompted, specify the parameter values. See related links about parameters at the bottom of this page.
Results
If an error occurs during the migration, the process stops until you take corrective action. After you correct the error, you can resume from where you left off by running the scripts given in the next paragraph on this page.

Troubleshooting

About this task

The logs that are generated during the migration process are located in the migration/logs directory.

To resolve problems in migrating the data warehouse:

  1. If you have a problem during migration, check in the logs for troubleshooting information, and correct the errors.
  2. Run the appropriate command for your data warehouse.
    • For DB2: From a DB2 command prompt, connect to the database use the DB2 administrator account and run the following command:
      db2 "CALL db_administrator_name.DW_MIGRATE('operational_data_store_schema_name','data_mart_schema_name','report_user_name')"
    • For Microsoft SQL Server: Make sure that you are logged in to the server as an administrator and, from a command prompt, run the following command:
      sqlcmd -S server\instance -d database_name -v CURRENT_SCHEMA="user_logged_in_currently" -b -l 60 -e -Q "user_logged_in_currently.DW_MIGRATE @ODS_SCHEMA='operational_data_store_schema_name',@DM_SCHEMA=data_mart_schema_name,@REP_USER='report_user_name'"
    • For Oracle Server: From an sqlplus session, connect to the database using the DBA account and run the following command:
      BEGIN 
      db_administrator_name.DW_MIGRATE('operational_data_store_schema_name','data_mart_schema_name','report_user_name'); 
      end; 
      /  
    If you run the command again, only those database statements are executed that failed earlier or are set to EXECUTE=1 with an execution status of 0 or null.
  3. To find out which statements were run, look in the CONFIG.STATEMENT_LIST table for the RET_CODE column, and you can see the SQLSTSATE/SQLCODE returned for the failed statements

Feedback