Performance issues while pulling the data from DB2

[system]

Hi All,

We are creating webi reports by pulling the data from DB2.
But the performance is very low.

can one worked with such kind of integrated reports? What are the steps to improve the performance?

Thank you

---

kencha (BOB member since 2010-05-11)

[system]

Hi,

Going through these hints could help:

Webi & Better Performance

Below is from my notes. Couple Questions: what am I missing below? “…Allocating table weights…”: how do I do that, and what are the benefits? “.…Minimizing usage of derived tables….”: What are the benefits? I thought having derived tables has zero effect --apparently I’m wrong– for XIR2 web.xml location is fine, for XIR3 there are more than one web.xml files exist, for timeout purposes which one to modify? thanks MrH =========================================== :: :: Faster WEBI Reports :…

---

Marek Chladny (BOB member since 2003-11-27)