Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page 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.

Panel layout

SQL Performance for DB2

 panels have a number of common characteristics, including various standard elements that are displayed on all 

SQL Performance

 panels and online reports and the use of confirmation dialogs.

Related topic

Getting-started-with-SQL-Performance

The following figure shows the common attributes that are shared by SQL Performance panels.

Panel_layout-BMC_AMI_Apptune_for_Db2_Main_Menu.png

 The following table describe the common elements of SQL Performance panels.
Elements

Element

Description

Panel ID

The panel ID displayed in the upper left corner of each panel. Display of the panel ID is optional. The default value is set in the User Profile. You can use the PANELID command to suspend the default temporarily.

Environment identifier

The environment identifier is displayed to the right of the panel ID, separated from it by a slash (/). Possible values are

  • I (when operating under ISPF)
  • P (when operating under native TSO)

Panel description

Each SQL Performance panel displays a description in the center of the top line of the panel.

Time or line indicator

Panel ID

The panel ID displayed in the upper left corner of each panel. Display of the panel ID is optional. The default value is set in the User Profile. You can use the PANELID command to suspend the default temporarily.

Commandline

Environment identifier

The environment identifier is displayed to the right of the panel ID, separated from it by a slash (/). Possible values are

  • I (when operating under ISPF)
  • P (when operating under native TSO)

Function keys

Panel description

Each SQL Performance panel displays a description in the center of the top line of the panel

Message

Time or line indicator

On nonscrollable panels, the time is displayed in the upper right corner in the format hh:mm:ss, where:

  • hh is hours in the range 00-23
  • mm is minutes in the range 00-59
  • ss is seconds in the range 00-59

On scrollable panels, the current line number and the total number of lines is displayed in the format LINEnnn OF nnn.

If the panel is scrollable, the scroll amount (in the format Scroll ===> ____) is also displayed at the end of the Command line. Each time you begin a SQL Performance session, the default scroll amount is retrieved from your User Profile and displayed here. You can change the scroll amount at any time, and the new value remains in effect until you change it or end your session. The following values are valid:

  • PAGE—Data is scrolled one full page at a time. A full page varies in size depending on the number of scrollable lines on the panel or report.

    Information
    Example

    If there are 10 scrollable lines on the panel, data is scrolled 10 lines at a time.

  • HALF—Data is scrolled a half-page at a time. A half-page varies in size depending on the number of scrollable lines on the panel or report.

    Information
    Example

    If there are 12 scrollable lines on the panel, data is scrolled 6 lines at a time.

  • CSR—The position of the cursor determines the number of lines scrolled. When scrolling down, position the cursor on the line to be displayed at the top of the scrollable area, and press F8. When scrolling up, place the cursor on the line to be displayed at the bottom of the scrollable area, and press F7. If CSR is specified and the scrolling keys are used when the cursor is not positioned on a scrollable portion of the panel, scrolling defaults to PAGE.
  • GRP—Data is scrolled one repeating group at a time. The first line of the next repeating group is displayed on the first line of the scrollable area. This value is valid only when viewing reports with repeating groups. If this value is specified, and there are no repeating groups on the panel, scrolling defaults to PAGE.
  • nnnn—Data is scrolled nnnn lines at a time, where nnnn is any number in the range 1 to 9999.

Command line

The Command line can be displayed directly beneath the panel ID and description or at the bottom of the panel directly above the function keys. The default value for the position of the Command line is set in the User Profile.

Function keys

The function keys are displayed on the bottom two lines of the panel. Display of function keys is controlled by a parameter in the User Profile. The default values for each key can also be modified in the User Profile. The following defaults are shipped with SQL Performance:

  • F1 - Help
  • F2 - Split
  • F3 - End
  • F4 - Sort A (ascending)
  • F5 - Sort D (descending)
  • F6 - Showcmds
  • F7 - Up
  • F8 - Down
  • F9 - Swap
  • F10 - Left
  • F11 - Right
  • F12 - Cancel
  • F13 - Home
  • F14 - Keys
  • F15 - End
  • F16 - Terse
  • F17 - Rfind
  • F18 - Filter
  • F19 - Up
  • F20 - Down
  • F21 - Expand all
  • F22 - Left
  • F23 - Right
  • F24 - Retrieve

Message

SQL Performance messages are displayed directly below the Command line when the Command line is displayed at the top of the panel, and directly above the Command line when the Command line is displayed at the bottom of the panel.

 

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

SQL Performance for DB2 13.1