For DB2®, the technique for obtaining a query execution plan depends on which DB2 version you are running.
On DB2 for versions other than 9.7, use the Explain plan methods for the exact query as executed by the Content Platform Engine (including bind markers).
Command | Comment |
---|---|
|
Use a portion of the query that is obtained from a P8 server trace after the query is run. |
|
Use the entire executable_id returned in the first query for the first argument. |
db2exfmt -d databaseName -e schemaName -w 2011-06-28-18.53.10.973000 -n SYSSH200 -s NULLID -t -# 0 | Use the -w explain_time, -n source_name, -s source_schema from last call. |