The Interactive SQL Service Facility allows you to display an index of all plans that currently exist in the dictionary.
You receive an error message telling you that no plans currently exist if there are none, or if you are not pointing to the active dictionary where the plan occurrences are defined.
Note: The online plan is usually deleted after successful execution. The DISPLAY PLAN option should therefore only show the plans created by embedded SQL in application programs. However, if an online plan is not deleted for some reason, such as an abend, it is displayed.
|
Copyright © 2014 CA.
All rights reserved.
|
|