DBRM Selection
The DBRM Selection screen (see the following figure) displays when a DBRM object type is selected on the SQL Plan Analysis Specification screen. DBRMs are listed in the same order as they are retrieved from the Db2 catalog.
DBRM Selection Screen
CMD
Specify the line command to be performed on the selected DBRM.
S | Displayed detailed information for the selected DBRM. The SQL Statement Selection screen shown in SQL Statement Selection Screen displays. |
X | Performs an Explain of the entire DBRM. If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Source Analysis screen shown in 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 shown in Batch Plan Analysis Reports Window displays. See Explaining-Objects-in-Batch for more information. To explain the DBRM, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If the DBRM cannot be explained, the error message NONE EXPLAINABLE displays. |
Sorting DBRM Entries
The SORT primary command can be used to change the order in which DBRM 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)
- Plan (PL)
- Time (TI)
For example, to sort the display by DBRM name, enter the command SORT NA.
Related topics