Explain existing entry in Plan Table

Edit online

Use the Plan Table Entry window to explain an entry in your plan table or, if you have the required Db2® authority, an entry in another user’s plan table. Regardless of the user specified, a Db2 plan table needs to exist for that user.

To display this window, select option 1 from the Explain Menu.

Figure 1. Plan Table Entry window

DGOMYWPE                 Plan Table Entry

Local location . . . . . . . : PMODB2A           SDA2  V13
Current server . . . . . . . : PMODB2A           SDA2  V13

Specify the owner of the plan table. Then either specify a
query number, or leave query number blank and enter plan,
program and version details for a list of query numbers.

Owner of plan table  . . . . . PMDEV51_______________________   +

Query number . . . . . . . . . _________

Plan name  . . . . . . . . . . ________
Program name . . . . . . . . . DGO@TPG1______________________   +
Version  . . . . . . . . . . . ______________________________   +

Command ===> ____________________________________________________
 F1=Help    F2=Split   F3=Exit    F9=Swap   F12=Cancel F21=Expand
F22=Left   F23=Right

Enter a user ID in the Owner of plan table field, or leave this field blank to specify your own plan table. Then specify the Query number of the plan table entry you want to explain.

If the 1 field is left blank, all entries are listed that match the plan name, program name, and version that you specified. Leaving any of these criteria fields blank is equivalent to specifying an asterisk (*), which matches all entries. The Plan Table Entry List panel is then displayed, which lists all matching entries in the plan table.

After selecting an entry in a plan table, the entry is processed and the result is shown in the Db2 Explain Output panel.