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

DCC/DW or LQE -- when are they used

Hello,

When creating reports, when do you know if you are using DCC/DW or LQE for the report? Is it if you are using SQL (Advanced) you are using LQE, or is it something else?

I ask b/c I was going through the tutorial here:

https://jazz.net/library/article/1562

Custom trend reports using work item history

And there is a section that asks you to edit the table/columns - done, previewed the report, great. Then it asks for you to  look at the Graph to edit -- no response. Instead, my server received two core dumps of 50GB and a LQE log file of 26GB rendering the server unreachable as it ran out of space..

0 votes



3 answers

Permanent link

Hello Mahari,

LQE is very resource hungry, the symptoms you describe makes me think of not enough resources assigned to LQE.

The recommendation for LQE is to have a dedicated computer with adequate CPU, memory and hard drive capacity. See the following article for more details:

Best Practices for Configuring LQE For Performance and Scalability
https://jazz.net/wiki/bin/view/Deployment/LifecycleQueryEngineBestPractices

Best Regards
Francesco Chiossi

1 vote


Permanent link

Hello Mahari,

this is where you select which data source your report will use:


Note: in the Advanced section you will see SQL queries for data warehouse reports and SPARQL queries for LQE reports.

Best Regards
Francesco Chiossi

0 votes

Comments

Thanks for responding. I guess my question forms from why LQE got out of control. I am not sure I did anything to cause the lqe.log file to jump to 26GB.


Permanent link

The log4j.properties has a default 10MB size on the log file and a limit on the number of log files to keep.  This controls the size of the lqe.log as well as the number of backups kept (on a rotating basis)

log4j.appender.file.MaxFileSize=10MB
log4j.appender.file.MaxBackupIndex=5

It is not uncommon for the indexTDB folder to grow to larger sizes as it is indexing data from all of the connected CLM applications if you configured LQE through JTS setup.

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
× 12,019
× 7,495
× 6,121
× 360
× 230

Question asked: Jan 20 '17, 7:27 a.m.

Question was seen: 4,857 times

Last updated: Jan 20 '17, 10:01 a.m.

Confirmation Cancel Confirm