Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Performance perspective


The commands in the Performance perspective enable you to analyze SQL statements, perform What-If comparisons, and migrate access path statistics for an object.

Related topic

Selecting a SQL statement for analysis (see Selecting-a-statement-for-SQL-Analysis ) displays the Performance perspective.

The Performance perspective provides access to the result view tabs, which enable you to perform the tuning process. Depending on the activities being performed, the following tabs can be displayed:

g_gud_SQL_Tuning_SPE2304.png

#

Description

1

Tuning session pane

2

Buttons for adding SQL statement views NW_plus_circle_o.png and removing NW_minus_circle_o.png views

3

Active workspace name

An asterisk (*) indicates that the workspace has unsaved changes.

4

Perspective tabs

The Performance tab is underlined with orange, indicating that it is the active tab.

5

Generate Explain plan button NW_generate_explain.png

The button is dimmed after the statement is successfully explained.

6

What-If button NW_create_what_if.png

The What-If button is dimmed on a selected statement if the statement has not been successfully explained. Unless the statement is successfully explained, you cannot create a What-If scenario based on that statement.

7

Compare button NW_compare_statement.png

This button opens the Compare dialog box.

8

Name and ID of the active statement

9

Run button NW_run.png

This button executes the statement on the SQL tab and displays the output on the Results tab.

10

Explain tree of the SQL statement

11

Result view tabs that show the result of explaining a statement, and catalog objects

12

Explain time stamp and Db2 subsystem name

13

Options button NW_gear.png

14

Migrate statistics buttonNW_file_arrow_right.png

This button opens the Migrate statistics dialog box.

15

(BMC.DB2.SPE2304)

Generate report button NW_file_text_o.png  

This button exports the current Explain plan to a PDF file.

16

Show graph view button NW_show_graph_view.png or Show tree view button NW_show_tree_view.png

These buttons switch the display between graph view and tree view.

17

Full screen button NW_full_screen.png or Close button NW_exit_full_screen.png

These buttons switch the display between full screen view and standard screen view.

g_gud_Performance_perspective_Dec16.png


#

Description

1

Tuning session pane

2

Buttons for adding SQL statement views Add-16.pngand removing Delete-16.pngviews

3

Active workspace name

An asterisk (*) indicates that the workspace has unsaved changes.

4

Perspective tabs

The Performance tab is blue, indicating that it is the active tab.

5

Generate Explain plan buttonexplain-24.png

The button is dimmed after the statement is successfully explained.

6

What-If buttonWhatIf-24.png

The What-If button is disabled (dimmed) on a selected statement if the statement has not been successfully explained. Unless the statement is successfully explained, you cannot create a What-If scenario based on that statement.

7

Run buttonexecute-24.png

8

Migrate statistics buttonStats-Migration_24x24.png

This button lets you migrate access path statistics for one or more objects.

9

Name and ID of the active statement

10

(Compare tab only) Explain tree of the first statement

Note

g_gud_changed.png indicates that at least one attribute of an object has different values in the two statements being compared.

11

The Result view tabs that show the result of explaining a statement, a compare, and catalog objects.

12

(Compare tab only) Explain tree of the second statement

13

Explain timestamp and DB2 subsystem name

14

Options buttonconfiguration-24.png

15

(Compare tab only) Attribute details of the second statement

16

(Compare tab only) Attribute details of the first statement

17

(Compare tab only) Attribute names

Note

g_gud_changed.png indicates that the attribute has different values in the two statements being compared.

This section provides more information about the following topics:

 

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