Upgrading ODS data during Insight upgrade
There's a step in the upgrade documentation that states you must upgrade the ODS data - http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.migrating.doc%2Ftopics%2Ft_migrate_odsdata_to1011.html.
I'm confused about the wording here. Should I run this right away even though we haven't upgraded to RTC or RQM 3.0.1, or should I wait until we do our upgrades? Also, we have +20 RTC repositories and we won't be upgrading them all at once. Since the Loop_RTC* job runs across all RTC connections at once, should we run this when we upgrade the first repo or wait until all are done? |
One answer
The job will help you to change "KEY" columns when you extract data into dw, so it's very important to avoid data confusion. Because RTC upgrade don't modify repository database schema, so whatever you run this job before or after RTC upgrade is ok. But it must be run before 1st time of extracting data from RTC 3.x.
If you have more than one RTC repositories, just like A B and C. Then A upgrades to RTC 3.x, and B/C keep 2.x. You could run migration on A first, then extract data from A by REST mode and keep B/C with database mode. That means you could individually upgrade RTC, but you must run migration job before extracting data from the individually upgrade RTC server by REST mode. |
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.