Creating explain snapshots

To display an access plan graph, Visual Explain requires the information contained in an explain snapshot. Explain snapshots are stored in explain tables.

If you have not already created explain snapshots, you can create them using one of the following methods:

• Use the sample snapshots provided. For information about how to load these, see Using sample snapshots.

• Use the instructions in either of the following sections:
  • Creating explain snapshots for dynamic SQL statements.
  • Creating explain snapshots for static SQL statements.

• Use the Explain SQL function in Visual Explain. This function creates explain tables, if they do not exist; creates an explain snapshot for a dynamic SQL statement; and displays the resulting access plan graph for the snapshot.

• Invoke the db2vexp command from the DB2 command line processor (CLP) prompt. This command generates an access plan graph for a dynamic SQL statement. For information about how to use this command, enter db2vexp -h on the command line, or see the Command Reference.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]