Whenever an SQL statement is explained, the result is written
as an entry into a plan table. When the Explain function performs
a dynamic Explain, the result is written to the PLAN_TABLE of the
current SQLID. The current SQLID is either the same ID as the one
used for your Online Monitor session or the ID that you specify in
the Explain Menu. You can then examine the explained SQL statement
residing in the plan table by using the DB2® Explain
Output panel and its associated windows.
If you request a dynamic Explain of an SQL statement, and if you
do not have an up-to-date plan table, one of these windows is displayed:
If a plan table currently does not exist, the Create Plan Table window prompts you to create a plan table.
If a plan table exists, but does not match your current version
of Db2, the Upgrade Plan Table windowprompts you to upgrade the plan
table.
Create Plan Table window
If
a plan table does not exist when a dynamic Explain is required, the
Create Plan Table window is displayed.
Use the Create Plan Table
window to specify the database name (optional), and table space name
of the table to be created (optional). If neither are entered, a plan
table is created in the default database DSNDB04. If this database
does not exist or you do not have sufficient authority, an error message
is displayed. Figure 1. Create Plan Table window
DGOMYWQC Create Plan Table
You do not have a plan table. Update the database name and table
space name as required, then press Enter to create the plan table.
Database name . . . . . . . . DSNDB04
Table space name . . . . . . .
F1=Help F2=Split F9=Swap F12=Cancel
Upgrade Plan Table window
If
a plan table exists but does not match your current version of Db2, the Upgrade Plan Table window
is displayed. Use this window to confirm that the table definition
be upgraded to match your current version of Db2. Figure 2. Upgrade Plan Table window
DGOMYWQU Upgrade Plan Table
Your plan table definition does not include all the columns
required by DB2PM.
To upgrade the plan table, press Enter.
F1=Help F2=Split F9=Swap F12=Cancel