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

How long will "upgrade data warehouse schema" take when upgrading CLM from 4.0.2 to 5.0?

Questions
Tags
Users
Badges
Markus Nosse
(151●1●28●28) Oct 30 '14, 10:26 a.m.
I have to upgrade a CLM 4.0.2 installation to version 5.0. When running the upgrade scripts, I noticed there is a step "upgrade data warehouse schema" which I never tried. For the production system upgrade however, this step has to be executed.

How long will this step take? (specifically, is there a dependency on the size of the warehouse database? By now it has approx. 500 million rows, DB2 requires approx. 120 GB for an offline backup of it.)

Thanks for your help!
Markus

1 vote

1 answer
7,550 views
1 vote

One answer

Permanent link
Markus Nosse
(151●1●28●28) Oct 31 '14, 10:21 a.m.
I went the extra mile of configuring a test environment with production data and connection to a data warehouse DB and applied the upgrade scripts on this setup.

To my great relief, repotools-jts.sh -upgradeWarehouse took only about two minutes.

Regards
Markus

2 votes

Comments
Ginny Ghezzo
JAZZ DEVELOPER Oct 31 '14, 10:32 a.m.
Markus, Thank you for not only doing the test but posting the results.    I will make sure our teams are aware of this question and the results you found.    I am curious why you are working on CLM 5.0 instead of the latest release CLM 5.0.1 (GA Sept 9, 2014)?   I strongly recommend while doing evaluation and test,  you leverage the latest mod release.   Also when an extended maintenance release is available, such as CLM 4.0.7 for version 4, it is in our customers best interest to be on it for defect and security resolution.   Thanks, Ginny

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.

Ask a question
Guidelines
FAQ
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
× 7,622
× 268

Question asked: Oct 30 '14, 10:26 a.m.

Question was seen: 7,550 times

Last updated: Oct 31 '14, 10:32 a.m.

Confirmation Cancel Confirm