Setting Command Center options

To change the filter options

1. From the console's main menu, click Signed in as > Options.
2. Select the General tab.

3. Select Filter Options.

   In all perspectives, this option converts all entered filter values to uppercase.

   Important

   After selecting (enabling) this option, you can override it for a specific filter by beginning the filter value with a quotation mark (").

   • Leave the check box selected if you want BMC AMI Command Center to convert all filter values that you enter to uppercase (the default).
   • Clear the check box if you want to preserve the case that you use when typing filter values.
4. Click OK.

To change the maximum rows returned

Use this procedure to set the maximum Db2 statement cache rows returned.

1. From the console's main menu, click Signed in as > Options.
2. Select the General tab.
3. Enter the Maximum rows returned. Valid values are 1 to 5000.
4. Click OK.

To enable syntax highlighting

(BMC.DB2.SPE2210)

BMC AMI Command Center syntax highlighting is keyword-based with very light parsing. It uses the list of keywords and built-in functions documented in IBM Db2 manuals. It does not detect syntax errors. Use this procedure to enable syntax highlighting.

1. From the console's main menu, click Signed in as > Options.
2. Select the General tab.
3. In the Syntax Highlighting Options section, select Use syntax highlighting for SQL statements.
   In the Scratchpad and Performance perspectives, this option determines whether syntax highlighting is enabled.
   After selecting (enabling) this option, SQL statements on the SQL Tuning tab of the Performance perspective are highlighted the next time you select the view. In the Scratchpad perspective, SQL statements are highlighted if the option was previously selected in the view.
4. Click OK.

To change the SELECT statement options

(BMC.DB2.SPE2404)

Use the following procedure to change the SELECT statement options used in the Performance and Scratchpad perspectives:

1. From the console's main menu, click Signed in as > Options.
2. Select the Select tab.
3. Select the decimal mark to use:
   
   • To use a period (.) as the decimal mark, select Decimal Point.
   • To use a comma (,) as the decimal mark, clear Decimal Point.

4. Enter the maximum values for the following items. The default values are shown in parentheses.

   • Maximum numeric length (10)
   • Maximum CHAR length (64)
   • Maximum VARCHAR length (64)
   • Maximum select rows (300), where valid values are 1 through 5000

   Important

   The total amount of returned data in the result set cannot exceed 20 MB; the Select Options settings do not affect that limit. If the limit is reached, the product alerts you with a message.

5. Click OK.