Skip to Content

SQL Plan Selection

The SQL Plan Selection screen (see the following figure) displays when a Plan object type is selected on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen). This screen is only displayed when the catalog contains more than one plan matching the specified object name. Otherwise, the DBRM/Package Selection screen (DBRM/Package Selection Screen) displays. On this screen you can select a plan to be analyzed or explained.

SQL Plan Selection

File-AID for DB2 ---------- SQL Plan Selection ---------- Row 1 to 14 of 14
COMMAND ===>                                                SCROLL ===> CSR
                                                                  SSID: DSN

Line Commands:
  S - Select Plan for more detail
  X - Explain entire plan

CMD  Plan Name   Creator   Bound By  Bind Date  Bind Time
---  ----------  --------  --------  ---------  ---------
_    SQLP2000    USERID1   USERID1   920227     15213063
_    SQLP1160    USERID1   USERID1   920313     07231183
_    SQLP2PKG    USERID2   USERID2   920331     11066144
_    SQLP3PKG    USERID2   USERID2   920331     17141717
_    SQLSAMP     USERID2   USERID2   920417     16472267
_    SQLROBIN    USERID2   USERID2   920420     10392170
_    SQLTEST     USERID2   USERID2   920421     11191932
_    SQLP1302    USERID2   USERID2   920424     16492837
_    SQLLONG     USERID2   USERID2   920619     17142798
_    SQLP2010    USERID2   USERID2   920729     12243555
_    SQLBIG      USERID3   USERID3   920916     09585582
_    SQL407      USERID3   USERID3   920930     14490213
_    SQLSAMP1    USERID2   USERID2   920923     14314954
*************************** Bottom of data ***************************

CMD

Specify the line command to be performed on the selected plan.

S

Displays detailed DBRM/Package information for the selected plan. The DBRM/Package Selection screen (DBRM/Package Selection Screen) displays.

X

Performs an Explain of the entire plan.

If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Analysis Summary screen (SQL Analysis Summary) displays.

If you entered 2 for batch processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the Batch Plan Analysis Reports window (Batch Plan Analysis Reports Window) displays. You may explain more than one plan by entering multiple X line commands. See Explaining-Objects-in-Batch for more information.

Warning

Important

To explain the plan, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If the plan cannot be explained, the error message NONE EXPLAINABLE displays.

Sorting Plan Entries

The SORT primary command can be used to change the order in which the plan entries are displayed. Multiple column names are not accepted. The selected columns are sorted in ascending sequence. The valid column names that can be used with the SORT command are listed below. Abbreviations are noted within parentheses.

  • Name (NA)
  • Creator (CR)
  • Boundby (BO)
  • Date (DA)
  • Time (TI)

For example, to sort the display by the bind time, enter the command SORT TI.

Related topics

SORT

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX File-AID for Db2 23.01