Setting SQL tuning options

You can use the Options button to set the behavior of the SQL tuning feature.

 To set the options for executing SELECT statements, use the BMC AMI Command Center Options dialog. For more information, see Setting-Command-Center-options.

Related topics

Tuning SQL

Setting Command Center options

The following tabs are displayed:

  • The Tuning tab sets the options for defining SQL tuning settings for the current session.
  • The Statistics Migration tab sets the options for statistics migration. For more details, see Setting statistic migration options.

Tuning tab

The Tuning tab lets you set the following types of options: dynamic SQL, ad hoc SQL, and general.

Dynamic SQL options

Option

Description

Default value

Plan Table Owner

Specifies the name of the owner for the Db2 plan table used

Important

If you want the owner to use lowercase characters, verify that you have not enabled Convert filter values to upper case. For more information, see Setting Command Center options.

BMC

 

Ad Hoc SQL options

Option

Description

Default value

Table Qualifier

Specifies a table qualifier to qualify Db2 objects that are not qualified in the SQL statement

No default value

Degree

Specifies whether to consider parallel processing during an Explain:

  • Any considers parallel processing.
  • 1 does not consider parallel processing.
  • Blank uses the value at bind time.

Any
 

General options

Option

Description

Default value

Rule set

Defines the Explain expert rules set to use:

  • DEFAULT displays all rules that are related to performance issues and are primarily relevant to DBAs.
  • APPLDEV displays rules that are primarily relevant to application developers.

The rules files are available in the hlq.llqSAMP data set. The name of hlq.llqSAMP varies depending on your BMC AMI SQL Explorer for Db2 installation options and might be hlq.BMCSAMP. The names of the members that contain the rules files are as follows:

  • PSSDFLT contains the DEFAULT rules.
  • PSSAPPL contains the APPLDEV rules.

For more information, see Expert rules.

DEFAULT

Online Application

Specifies whether to trigger specific rules for table space scan, list and sequential prefetch, and multiple index access paths (MIAP) considerations:

  • Select to trigger the rules.
  • Clear to avoid triggering the rules.

Unchecked

Cost Translation Rate per Timeron

Specifies the rate used to translate the timeron cost into a monetary unit

1.0

Cost Translation Rate per Service Unit

Specifies the rate used to translate the service unit cost into a monetary unit

1.0

 

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