It's all about the answers!

Ask a question

Anyone having performance issues with Jazz Reporting Service ?

Kevin Ramer (4.5k8180199) | 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.4k371103) | 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.