It's all about the answers!

Ask a question

move DW database from one db2 server to another db2 server


Sonic Ning (1314) | asked Mar 26 '14, 2:30 a.m.
retagged Mar 26 '14, 5:42 a.m. by Francesco Chiossi (5.7k11119)
Hi,
   We need to move only the DW database from one db2 server to another one, as there was some mistake in the DW JDBC configuration.
  JTS/QM/RM databases are in db2 server1. But somebody pointed the DW database to db2 server2, and mixed up with Rational Insight data. DW database in db2 server1 contains very old data we don't need. DW database in db2 server2 contains  Rational Insight data along with data from db2 server1.
We need to change the JDBC Location in Server Administration -> Reports -> Data Warehouse Connection
from //hostname1:60000/RIDW:user=db2inst1;password={password};  
to //hostname2:60000/DW:user=db2inst1;password={password}; 
   As far as I know, the data from DW database comes from etl jobs.
   Can we just drop DW in db2 server1 and create an empty DW in db2 server1 ?(as we don't want Rational Insight data mixed with this DW data)
   Or we still need to move old DW to db2 server1 with old Rational Insight data ?
   Any ideas would be appreciated?
Regards
Sonic
  

Accepted answer


permanent link
Francesco Chiossi (5.7k11119) | answered Mar 26 '14, 5:35 a.m.
edited Mar 26 '14, 5:43 a.m.
Hello Sonic,

you can create an empty data warehouse on db2 server1and repopulate it with the CLM data collection job.
The first run will be a full load (that is 12h work item job that you noticed) and will fully repopulate the operational data store part of the data warehouse.

You will anyway lose the metrics part, as this is not recreated (this is used for reports based on metrics like for example burndown charts).

Migration jobs are probably due to the fact that this was the first run against an empty data warehouse.

Best Regards,

Francesco Chiossi
Sonic Ning selected this answer as the correct answer

Comments
Sonic Ning commented Mar 26 '14, 8:56 a.m.

Thanks Francesco

We have to check if we can afford losing the metrics part or not.
Regards,
Sonic

One other answer



permanent link
Sonic Ning (1314) | answered Mar 26 '14, 2:52 a.m.
edited Mar 26 '14, 2:58 a.m.
BTW
I did some tests in our test environment.
I changed it.
That is the data collection jobs seems all OK
What does that migration mean ?
The first work item collection job took about 12 hours to complete
Does that mean , it was rebuilding the data warehouse from the blank?

Regards
Sonic
 

Your answer


Register or to post 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.