Thanks for the response. The same report and data in version 7 worked fairly quickly. In version 8 the response is terrible. Sort buffer makes no difference I have used 16mb and 32mb no diff. If i take off group columns yet keep aggregate data I still see the db2 group sql and performance is...
With Cognos8 / DB2 when trying to group or sort any column on a large table i am blowing up on memory or temp space /
using version mr2 has anyone else experienced this problem?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.