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.
Are you sure that the Query Subjects have properly modelled joins. Blind Spots and poor performance are often related to incorrect joins in the model. I can't imagine that you could have created a terribly complex query in Query Studio, so it seems like an infrastructure problem to me.