Collection ID Selection
The Collection ID Selection screen (see the following figure) displays when a Collection ID object type is selected on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen).
Collection ID Selection Screen
CMD
Specify the line command to be performed on the selected collection ID.
S | Displays detailed information for the selected collection ID. A Package Selection screen similar to the one shown in Package Selection Screen displays. The only difference is that the packages displayed are for a specific collection ID which is noted at the top of the screen. |
X | Performs an Explain of the entire collection ID. If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Analysis Summary 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. Note: To explain the Collection ID, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If it cannot be explained, the error message NONE EXPLAINABLE displays. |