Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. |
Plan Table Analysis
The Plan Table Analysis screen displays when you:
- Select a DBRM/Package on the SQL Analysis Summary screen (SQL Analysis Summary).
- Select a statement on the SQL Statement Selection screen (SQL Statement Selection Screen).
- Issue the XP line command in SQL Source Development and Analysis or select option 3 from the Host Variable Resolution screen. See ISPF-PDF-SQL-source-development-and-analysis for more information.
It displays the entire SQL statement and enables you to receive an access path analysis, explain detail, a predicate analysis, and catalog information for the SQL statement. Scroll to the previous or next SQL statements with the PREV and NEXT primary commands.
Plan Table Analysis Screen
OPTION
Enter the desired option.
1 | Displays an Access Path Analysis for the plan (Access Path Analysis Screen). |
2 | Displays the Explain Detail for the plan (Explain Detail Screen). |
3 | Displays a SQL Predicate Analysis for the plan (SQL Predicate Analysis). |
4 | Displays catalog information for the package (Table Information screen). |
5 | Displays Cost Detail information for the package (Cost Detail Information Screen). |
6 | Displays Function Detail information for the package (Function Detail Information Screen). |
This section provides information about the following topics: