with Tags: db2exfmt X
On collecting the average query execution duration and access plan for the DB2 database Community Blog
Aleksander Kovač Tags: explain db2 plan sql query performance db2batch db2exfmt commerce 1,651 Visits
When a client reports a performance issue, or I stumble upon it myself, I sometimes find it necessary to collect specific database related information for the purpose of identifying the problem, or deciding if the DB2 support team should continue to resolve...
from Blog: WebSphere Commerce SupportModified by Aleksander Kovač
DB2 UDB LUW As an extra precaution step to see what impact an index recommended by the db2 index advisor would have on a query execution plan, you may want to evaluate the impact before creating the actual index.. DB2 has the capability, to Evaluate...
from Blog: DB2 UDB LUW--Adminstration-Tips
SergeRielau Tags: section function profile db2exfmt actuals procedure explain trigger 17 Comments 46,505 Visits
UPDATE: Feb 11, 2012 I have added a TRACE procedure and renamed ENABLE/DISABLE_EXPLAIN_ACTUALS to ENABLE/DISABLE_ACTIVITY_MONITOR. The TRACE procedure returns a formatted trace of all SQL monitored by the activity monitor. This includes nested compiled...
from Blog: SQL Tips for DB2 LUW