Hi Experts,

How to view access plan or execution plan in DB2?

In control center we have a tab for access plan but i am not able to see that?

Please help

TIA

I don't know where you can't see this tab. Clicking on it shows you the access plan for the given SQL statement. Another alternative is the db2expln utility, which gives you the access plan as ASCII art.

Hi Stolze ,

Thanks for the reply

I am using Db2 9.5C Express is that a problem?

Hi,

well, i have all of my statements sitting in a snapshot table, so i generate a text file with all this statements (ie. dyn_sql.txt).

later, from db2 console (under linux ) i execute this:

set current explain mode explain
db2 –tf dyn_sql.txt

and my problem is that obtain this message error for each statement that contains "bind variables"

"SQL0313N The number of host variables in the EXECUTE or OPEN statement is not equal to the number of values required. SQLSTATE=07004"


How can i resolve this error message?

thx in advance

p/d: sorry for my english

Please start a new thread when asking a new question. You will get a better response.

Andy

If I remember correctly, you have to have the explain tables created under the user that is logged into command editor in order to see the access plan tab.

Andy