Open the Access Plan Graph window

To open the Access Plan Graph window, use one of the following methods:

  1. Open either the Explainable Statements, or the Explained Statements History window. Select Statement->Show access plan. The Access Plan Graph window opens.

  2. 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.

  3. 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.