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

LQE vs DW in 606

Questions
Tags
Users
Badges
Sean F
(1.3k●2●52●162) Sep 21 '18, 10:07 a.m.
I was testing JRS on a standalone environment.

I found that the DW source always seemed to report out of date data.

When I switched to LQE the reported data was always fresh.

Is this a valid reason for choosing LQE over DW?

Which data source are most folk using in production environments for JRS and why?


0 votes

1 answer
1,284 views
0 votes

Accepted answer

Permanent link
Davyd Norris
(3.0k●2●17) Sep 21 '18, 8:55 p.m.
DW runs its ETL jobs on a schedule, which by default is done at 1AM and 3AM every night. LQE runs its jobs every 5 minutes or so.

You can increase the frequency of the DW jobs but this will have a performance impact on the server - I would recommend you do it at the lowest load times
Sean F selected this answer as the correct answer

0 votes

Comments
Sean F
Sep 22 '18, 5:01 a.m.

Thanks Davyd

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

Question asked: Sep 21 '18, 10:07 a.m.

Question was seen: 1,284 times

Last updated: Sep 22 '18, 5:01 a.m.

Confirmation Cancel Confirm