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

Time estimation on CLM_all ETL job

Questions
Tags
Users
Badges
Amir Ghaemian
(48●1●13●15) Aug 06 '12, 10:21 a.m.
Hi

We have a CLM installation with a DB of 50GB. I need to try and estimate how long it would take to do a first initial full ETL of the data to the Insight DW using the ootb ETL job.

I know that you probably need more info than just DB size to estimate this and would like to know what more type of info I would need?

Also is there anyone that have done such estimations and how to calculate it?

P.S. I don't need very precise estimations rough ones are good enough.

thanks
Amir

0 votes

2 answers
5,828 views
0 votes

2 answers

Permanent link
Leonardo Marzo
(249●6●48●52) Aug 06 '12, 10:53 a.m.
 Amir, 

We have a 16Gb database and it took around 26 hs (JTS and CCM).  Of course it also depends on the hardware you have. We have two servers, one for the application and the other for the database. The hardware of both servers is:

Intel(R) Xeon(R) CPU   X5650  @ 2.67GHz, Dual 6 Core
RAM 8Gb


Hope it helps you.

Regards, 

0 votes

Comments
Amir Ghaemian
Aug 07 '12, 5:50 a.m.

Hi, thanks for the info it helps a bit do you know how many projects you had?

Leonardo Marzo
Aug 07 '12, 9:37 a.m.

Around fourty .

Permanent link
Jackie Albert
(1.6k●1●49●47) Aug 07 '12, 9:33 a.m.
This will also depend on where you're running the ETL from - I've found the Windows ETL to be 2x faster than the equivalent ETL on Linux so I'd recommend using Windows, particularly for a full load.

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.

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,497

Question asked: Aug 06 '12, 10:21 a.m.

Question was seen: 5,828 times

Last updated: Aug 07 '12, 9:37 a.m.

Confirmation Cancel Confirm