It's all about the answers!

Ask a question

Anyone having performance issues with Jazz Reporting Service ?

Kevin Ramer (4.5k9185200) | asked May 06 '15, 3:03 p.m.
edited May 06 '15, 3:16 p.m.
Just deployed this recently on a several year old JTS "cluster" and users are trying to create reports.  I noticed that my DB2 host is steady at about 70-90% CPU use since late yesterday.  I've tracked it to several db2 agents on the warehouse database that are reading millions of rows without making much progress.

I chatted with a user that is trying to use JRS and he relates that after trying to build a report, the application becomes unusable.   He noticed that joins are poorly done ( e.g. all columns of joined tables are in the SQL, sometimes making the statement too large / complex )

CLM 5.0.2 ifix003

One answer

permanent link
Krzysztof Ka┼║mierczyk (7.5k478103) | answered May 06 '15, 3:12 p.m.
Hi Kevin,
I would suggest you opening a new PMR where the support could look into the issue and see what are the queries causing performance degradation.

Your answer

Register or 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.