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

CLM ETL jobs execution after upgrade to Insight

Questions
Tags
Users
Badges
Ruslan Luchnikov
(31●2●13●11) May 27 '13, 9:39 a.m.
Hi, all
We upgraded RRDI v.2.0.1 to Insight 1.1.1. Insight to integrate with CLM 4.0.2.  After upgrade, ETL jobs execution became to slow. For example time of Java ETL execution 8-9 hours, ETL execution in Data Manager 20 hours.
Data warehouse database  Oracle 11.2.0.2. How can to optimize ETL jobs execution?

Thanks in advance.

0 votes

Comments
Xuan Jiang
May 27 '13, 9:46 a.m.

Ruslan - Can you provide the Java ETL log and/or the DM ETL log, as well as the JDBC log? BTW, how long before you upgrade?

2 answers
4,616 views
0 votes

2 answers

Permanent link
Ruslan Luchnikov
(31●2●13●11) Jun 03 '13, 2:26 a.m.
I found my mistake. I included in the job OOTBE2E - CLM4.0.1_All and jobs for RTC,RQM and RRC also. Now I'm left the job CLM_All, and time execution the DM ETL decreased.

1 vote

Permanent link
VK L
(817●7●157●159) Jun 03 '13, 5:19 a.m.
 Hi Ruslan,
                   You can configure delta loads to run everyday so that only the incremental changes are updated and will be minimal.
Initial run will require a full load

Thanks.

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
× 6,125

Question asked: May 27 '13, 9:39 a.m.

Question was seen: 4,616 times

Last updated: Jun 03 '13, 5:19 a.m.

Confirmation Cancel Confirm