We are running DB2 EEE V7.2 FP6 on AIX 5.1 on 2 servers with 3 nodes.

We are trying to find out when a query will use table scans and or indexes to get it's result set back. Is there a way to see the access path taken by the query using native DB2 utilities? If so how?

thanks in advance

mark

Mark,
You can use EXPLAIN. Also you could use the Command Center, turn on the option to generate an access plan.

HTH

Andy

There are a couple of options :

1) Visual Explain
Explain output is in graphical format. USe Command Centre.
2) db2expln
Explains the contents of a package. Issued from OS command line
3) dynexpln
Explains dynamic statements. The input to the command is a set of SQL Statements.
4) db2exfmt
Formats the contents of the EXPLAIN Tables ... Text 'Equivalent' of visual explain ...


Cheers
Sathyaram