Upgrading

Upgrading to newer versions of IBM® Rational® Insight.

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