Correspondendo a: db2exfmt X
On collecting the average query execution duration and access plan for the DB2 database Blog da Comunidade
Aleksander Kovač Marcações: explain db2 plan sql query performance db2batch db2exfmt commerce 2.044 Visualizações
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...
do Blog: WebSphere Commerce SupportModificado em por Aleksander Kovač
udbpros-shashimannepalli Marcações: virtual db2exfmt luw db2 index udb 1 Comentário 3.348 Visualizações
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...
do Blog: DB2 UDB LUW--Adminstration-Tips
SergeRielau Marcações: section function profile db2exfmt procedure actuals explain trigger 17 Comentários 47.220 Visualizações
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...
do Blog: SQL Tips for DB2 LUW