To open the Access Plan Graph window, use one of the
following methods:
- Open either the Explainable Statements, or the Explained Statements History window. Select
Statement->Show access plan. The Access Plan Graph window
opens.
- Invoke Explain SQL from either the Explainable Statements or the Explained
Statements History window. The Access Plan Graph window opens as a
result of the dynamic explain.
- Invoke the db2vexp command, specifying the database name, SQL
statement, and other optional parameters. The Access Plan Graph window
opens as a result of the dynamic explain.