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

Anyone having performance issues with Jazz Reporting Service ?

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
JRS: 

0 votes



One answer

Permanent link
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.

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

Question asked: May 06 '15, 3:03 p.m.

Question was seen: 3,366 times

Last updated: May 06 '15, 3:16 p.m.

Confirmation Cancel Confirm