Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Moving DW-tables to new database


 When installing the DW initially in my setup of CLM 3.0 I made the mistake to install the data warehouse tables in the same database as CCM. Now I'm facing some problems with tuning the DB (DB2) and I would like to have different databases (of course) for CCM, JTS and DW. 

How can I move the DW-tables to a new database? Or is it possible to recreate the DW and the re-populate it from CCM and JTS databases?

Please advice.

Best regards,
/Fredrik

0 votes


Accepted answer

Permanent link
You can drop the DW tables from the CCM DB, and recreate the DW in a seperate database. Once the tables are created correctly, you can run your ETL (data collection jobs) which will extract all the data from CCM and your other applications and store it in the DW.
Fredrik Jägare Lilja selected this answer as the correct answer

1 vote


One other answer

Permanent link
Hello Fredrik,

just an additional thing you should be aware of, is that by dropping and recreating/repopulating the data warehouse you are going to lose the metrics and trending data from the past.
They will be available in the new data warehouse only from the date of the first data collection job, onwards.

Best Regards
Francesco

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121
× 84

Question asked: Dec 11 '12, 5:46 a.m.

Question was seen: 4,999 times

Last updated: Aug 05 '13, 11:49 a.m.

Confirmation Cancel Confirm