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.

When should I use a space announcement banner?

Use the space organization announcement after you change the content from a book-like organization (such as User Manual, Configuration Manual, and Administration Guide) to the product model.

Use the latest version announcement to push traffic to later versions. You do not need to add this to every previous version, but if you have a specific reason that you want users to be aware—for example, Google searches show content for an obsolete version—use the banner to help users find a relevant version.

When an announcement is no longer needed, remove the BMC Space Banner macro.

Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

SQL plan analysis

The SQL Plan Analysis function of File-AID for Db2 enables you to examine the performance efficiency of your SQL statements.

Select option 1 from the SQL Analysis and Development menu (SQL Analysis and Development Menu). The SQL Plan Analysis Specification Screen displays. On this screen you can explain a plan, DBRM, collection ID, or package and obtain rules-based analysis in plain language. An SQL predicate analysis is also available.

SQL Analysis uses a 2 phase processing approach for SQL Analysis:

  1. Summary data from the Explain Tables is obtained from Db2 and is used to build the SQL Analysis Summary panel (SQL Analysis Summary).
  2. Detail data from the Explain Tables is obtained from Db2 when you select an SQL statement for further detail.

The current SQLID value is obtained prior to the summary data query being issued (phase 1). This SQLID is used for all queries until one or both of the following occurs:

  • You change the current SQLID to a new value and issue an SQL command in Access Path Analysis or Predicate Analysis and change the SQL statement text. This results in a new Db2 EXPLAIN being performed. In this situation, the new SQLID value is used for the newly explained SQL statement.
  • You change the current SQLID to a new value before issuing a new explain of a Db2 Plan, Collection ID or Package. The new SQLID value is used for all subsequent explains.

Important

If you don’t have existing Explain Tables and you select option 1, File-AID displays the Create Explain Table(s) screen where you enter the database name and, optionally, a tablespace name for the Explain Tables to be created. Once they are created, File-AID returns to the SQL Plan Analysis Specification Screen.

The flow chart in the following figure shows you how to navigate through the screens when processing the analysis in online mode. See Explaining-Objects-in-Batch for information on batch processing.

SQL Plan Analysis Flow Chart — Online Processing Mode

image2021-3-11_17-38-27.png

This section provides information about the following topics:

 

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