Issue on Report Performance

[ranne_78]

Hey Guys,

We have reports in Query studio.Those reports are in Production
now.  When Business user is trying to run those reports those
are taking much time i.e nearly 5 or 6 hours even though they
are not giving exact and accurate  results. We are getting only
piece of data . we are using Alias/Tables in the DB2 Main frame
database. For some query items it is not showing data at all.

Can any one help me to get the good performance for Query studio
reports.

Thanks.   

[BIsrik]

I feel the problem must be with the joining the tables. Select the sql generated from the query (in FM) and run it in the database server and check the timing..

Srik