PDA

View Full Version : DB2 performance



dtimmons
10-15-2007, 03:45 PM
Hi, I have Ad Hoc query working with a DB2 database, but have some performance questions. When I group the data by a column, I get pretty good response. If I don't group the data, it takes forever to come back. I filter based on a column that is the first in the clustering index, so I would expect pretty good response even without the grouping. Did I miss something when defining the metadata? Also, is there a way to see the SQL that is being executed?

Thank you,
Dan

MattCasters
10-16-2007, 01:42 PM
Hi Dan,

To debug the SQL we have an "MQL Query Builder" that will allow you to see the generated SQL
You basically make the same selection as in WAQR and then hit the SQL button at the top.

IIRC, the other option is to look at the JBoss logging.

HTH,

Matt