Error trying to validate remote Data Warehouse database during Rational Insight 1.1.1.1 setup?
I have installed Rational Insight 1.1.1.1 on a Windows 2008 server, and I'm trying to create and configure the databases on a remote AIX server.
The Content Store is fine, but I cannot validate the Data Warehouse database. It just tells me that "The database was created by a previous version. Run the migration tool to migrate the data warehouse to the current version." I created the RIDW database with the correct buffer pools and tablespaces, and successfully ran all the scripts that were generated. I then went back and tried to create a local database and this was created and validated without a problem. I even tried taking this local database and using db2move to move it to the remote server, but still got the same error when trying to validate it. Anyone seen this behaviour? |
Accepted answer
Hi Derek - good stuff. Yes the Run Now button can execute the script against the remote database.
Derek White selected this answer as the correct answer
|
2 other answers
When I first created the remote database, "Run Now" and "Save" buttons appeared after I clicked on the "Validate" button. I selected Save (because I thought Run Now would only work with a local database), copied the scripts to the remote server and ran them from there.
This time I chose Run Now, and it worked perfectly! So, problem solved. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.