Open the Explained Statements History window

To open the Explained Statements History window, do one of the following:

• From the Control Center, expand the object tree until you find the Databases folder, expand the folder until you find the database you want, and then do one of the following:

  • Click mouse button 2 on the database and select Show explained statements history from the pop-up menu. or select Selected->Show explained statements history.

  • Highlight the database and select Selected->Show explained statements history.

  The Explained Statements History window opens.

• From the Control Center, expand the object tree until you find the Packages folder (under the Application objects folder). Then:

  • Click on the Packages folder. Any existing package objects are displayed on the right side of the window (the contents pane).

  • Click mouse button 2 on the package that you want, and select Show explained statements history from the pop-up menu; or highlight the package and select Selected->Show explained statements history; or simply double-click on the package.

  The Explained Statements History window opens.

• From the Explainable Statements window, select Statement->Show explained statements history. The Explained Statements History window opens.

  If a statement is selected in the Explainable Statements window, the Explained Statements History window shows all of the explained statements that are related to the selected SQL statements.

  If no statement is selected, the Explained Statements History window shows all the explained statements that are related to the package that the explainable statements are in.

The Explained Statements History window may or may not contain explained statements, depending on whether the explain tables exist.

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

[ DB2 List of Books | Search the DB2 Books ]